• IT Knowledge Exchange’s iPad Contest Starts Today!

    Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or...

    MelanieYarbrough6,345 pointsBadges:
  • Converting from Access 2003 to Access 2007

    hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop's. because of that diference i convert for two...

    BUG68235 pointsBadges:
  • The future of PHP

    Big companies are not working in php. so what is the future of php?

    Sudiprai1010 pointsBadges:
  • Sending -/+ Number from VB.NET to COBOL

    Is it possible for someone on the VB.NET side to send a -120 to a COBOL program? The COBOL program LINKAGE SECTION is WS-AMOUNT PIC S9(3). The only way I got it to work is having the VB.NET person to send "12}" in char field. Just figured there was a way they could send like they normally would...

    BeanBaggs220 pointsBadges:
  • DB2 table load JCL with current timestamp

    Hi I need load the data from the flat file to db2 table by dsnuproc (mainframe ) utility my file dont have the timestamp value but the cloum in the table col2 declared as timestamp not nulll caould you please help how do load current timestamp.Thanks in advance Regards Manju

    Manju25 pointsBadges:
  • Running Multiple SQL statements through JCL

    I need to run multiple sql statements seperatd by ';'. I want the execution to continue for all the SQL statements even if any of the SQLs throws out error. Is it possible?

    Vmfquest5 pointsBadges:
  • Adding another level of security to SQL 2005 database

    We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security - requiring a SQL username and password along with a valid user name and password on the domain?

    NewnanIT1,110 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    project plan with steps outlined

    Anflores5 pointsBadges:
  • Rename file in CL

    Hi all. I need to check if the file exist, and rename it. t How do I check file existing in CL? Thank you.

    Larisagas265 pointsBadges:
  • Creating Access Form

    I have a table where I want to query partial phrases or words and cannot figure out a simple way to accomplish this. I used the brackets [] in the underlying query but cannot figure out an easy way to retrieve data with partial info.

    Tbill655 pointsBadges:
  • SQL View over a table with members

    Hi all, I have an as/400 table(fileA) with several members, I need to create view that joins this to several other tables but but I need to only target one member in fileA. The other tables are all single member tables. I tried to create an alias over the table and then create the view but that is...

    Lpgast0 pointsBadges:
  • AS400 RPG – last three digits of microseconds always zero!

    We noticed in a couple of programs where we were using timestamps that the rightmost three positions are consistently zero and never otherwise. I have tested this with even just a simple ILE RPG program that dsplys a %char(%timestamp()); and still only get zeros for the last three digits....

    Koohiisan5,020 pointsBadges:
  • Recovering database files from failed Brightstor 12 server

    We have a failed brightstor 12 server. I can recover the files from the hard drive but the server is dead. We will be rebuilding a new one. Can I recover the database files and import them? And if so where are they located?

    Troubleshooter24755 pointsBadges:
  • Alter proc to fetch a table structure from SQL Server 2005 database

    hi please segest me... what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N'?') begin print N'' print N'Usage: sp_table_struct @tablename, @flags...

    Amitshukla60 pointsBadges:
  • Formview from gridview in Visual Basic

    How does one automate by clicking a row in gridview to show a form populated with the clicked row data in visual basic for windows not asp.net

    Rafik25 pointsBadges:
  • Linked Server Query Returns Incomplete Results

    I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select * from...

    Apickel350 pointsBadges:
  • Execute trigger only on update of selected fields

    We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately...

    r.otto810 pointsBadges:
  • Install MySQL as Non-Root User

    Have you been able to install MySQL as a non-root user, if so what steps did you follow.

    Djp0820 pointsBadges:
  • Photo upload in a profile with PHP and MySQL?

    Please help me by giving script for uploading and updating member photo in his profile using php and mysql

    Shreeuram45 pointsBadges:
  • How can I email a query output from Access 2003?

    I have a query that runs form a table, the table have data for multiple customers, I give the query the customer numbers, it gives me the customer statement, I then copy and past the statement to excel and email it to the cutometer. I need to automate process if access allows me to do so

    MahmoudAly5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following