The most-watched IT questions this week: Oct. 20, 2009
Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...
Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...
720 pts.
Suppress FTP messages
I've got a program that FTP's (put) files to another system. I always used the program in batch mode. Now I'm trying to ref the program interactively. But message 'Press ENTER to end terminal session.' requires user intervention. Does any know how I can suppress FTP messages while running in...
I've got a program that FTP's (put) files to another system. I always used the program in batch mode. Now I'm trying to ref the program interactively. But message 'Press ENTER to end terminal session.' requires user intervention. Does any know how I can suppress FTP messages while running in...
Tracking data changes on IBM i with triggers
Hi I like to implemnet this tip can you share the sources files of this tip
Hi I like to implemnet this tip can you share the sources files of this tip
Domino on the iSeries and MS Excel
We have a LotusScript agent running on a Domino Windows server that opens an Excel spreadsheet and then processes each line of the file against data in the Domino DB. If we move our Domino platform from Windows to IBM iSeries, what additional considerations do we need in order for this process to...
We have a LotusScript agent running on a Domino Windows server that opens an Excel spreadsheet and then processes each line of the file against data in the Domino DB. If we move our Domino platform from Windows to IBM iSeries, what additional considerations do we need in order for this process to...
I Series Access Problem
We are installing I Series Access on a Dell Desktop with Vista Ultimate. When we go to load the software we click on the language question and and it says I Series access being installed and immediately come up with the following message: Could not read value version from key SOFTWAREIBMClient...
We are installing I Series Access on a Dell Desktop with Vista Ultimate. When we go to load the software we click on the language question and and it says I Series access being installed and immediately come up with the following message: Could not read value version from key SOFTWAREIBMClient...
AS/400 how to move spool file queue to queue ?
Suppose there 100 spool files in one queue name QEZLOG now i wants to move all the 100 file to another queue LIBOL , So usually we do the command by selection the file 2 and command is OUTQ(LIBOL) SAVE(*YES) but this is lenthy and taking more time , I need one command where all file will be moved...
Suppose there 100 spool files in one queue name QEZLOG now i wants to move all the 100 file to another queue LIBOL , So usually we do the command by selection the file 2 and command is OUTQ(LIBOL) SAVE(*YES) but this is lenthy and taking more time , I need one command where all file will be moved...
Five t-shirts to give away: Upload those profile pictures!
I've been noticing a dropoff in profile pictures lately -- here's a reminder on how to upload yours if you haven't already. If you're participating in the community, we want to know who you are! I'll be mailing out five t-shirts to the first five people (with eligible mailing addresses) to upload...
I've been noticing a dropoff in profile pictures lately -- here's a reminder on how to upload yours if you haven't already. If you're participating in the community, we want to know who you are! I'll be mailing out five t-shirts to the first five people (with eligible mailing addresses) to upload...
Purpose of binding directory in CGIDEV2?
I'm a little stuck. I'm trying to follow some guides regarding using CGIDEV2 on my iSeries V6R1 to do AJAX. I've looked at easy400.net as well as some other references, but I keep having the same issue. I keep getting error CPF980F 'Binding directory [dir] in library *libl not found.' Do I...
I'm a little stuck. I'm trying to follow some guides regarding using CGIDEV2 on my iSeries V6R1 to do AJAX. I've looked at easy400.net as well as some other references, but I keep having the same issue. I keep getting error CPF980F 'Binding directory [dir] in library *libl not found.' Do I...
Justify right in COBOL
I have data where the format has been changed slightly by the carrier and now this change is causing my job to abend. The last page number of each file reads ex.'160 OF 160' however, the new format must read '160 of 160' which means that the last page number needs to justfied to the right to pos...
I have data where the format has been changed slightly by the carrier and now this change is causing my job to abend. The last page number of each file reads ex.'160 OF 160' however, the new format must read '160 of 160' which means that the last page number needs to justfied to the right to pos...
STRQMQRY in batch on i5
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL
Journaling a file
Hi, I recieve the following error when i journal a file Damage prevents object from being journaled. Cause . . . . . : A damaged object previously journaled to this journal prevents journaling from being started for object in library type *QDDS. If the object is an...
Hi, I recieve the following error when i journal a file Damage prevents object from being journaled. Cause . . . . . : A damaged object previously journaled to this journal prevents journaling from being started for object in library type *QDDS. If the object is an...
Most popular blog posts this week
10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...
10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...
ILE O spec to print file
I am looking for a program to convert ILE O spec to a print file. Software/Hardware used: AS/400
I am looking for a program to convert ILE O spec to a print file. Software/Hardware used: AS/400
Iam unable to view graph details of Performance data for more than one day.
I use GO PERFORM to view by graph of the cpu usage etc during the day. Though i have configured the retention period for 15 days, i am able to view graph for data of the previous day only. Iam unable to view graph details of Performance data for data older than the previous days data. What do i...
I use GO PERFORM to view by graph of the cpu usage etc during the day. Though i have configured the retention period for 15 days, i am able to view graph for data of the previous day only. Iam unable to view graph details of Performance data for data older than the previous days data. What do i...
Iseries Deleted User Profiles
Hello, Where iSeries keeps deleted user profiles info and how can we retrieve that information. I believe iSeries keep somewhere user profile info in a database. What database is that. Thanks in advance. Syed Hasan
Hello, Where iSeries keeps deleted user profiles info and how can we retrieve that information. I believe iSeries keep somewhere user profile info in a database. What database is that. Thanks in advance. Syed Hasan
Save/Restore spoolfiles V5R3
We are on V5R3 and are about to upgrade our disks prior to going to V5R4. Does anyone know how to save AND restore spoolfiles including tose with attribute *USERASCII? Thanks. Software/Hardware used: V5R3
We are on V5R3 and are about to upgrade our disks prior to going to V5R4. Does anyone know how to save AND restore spoolfiles including tose with attribute *USERASCII? Thanks. Software/Hardware used: V5R3
Dropping a DB2 Stored Procedure
In my DB2 stored procs I always first drop the procedure and then do a create statement. Is there any way I could say something like...if exists (select * from sysroutines where routine_name = 'procname') then drop procedure procname; ? I tried this, but the proc doesn't like the IF...
Answer Question
| Oct 15 2009 5:32 PM GMT
DB2 stored procedures, iSeries DB2, AS/400 stored procedures
In my DB2 stored procs I always first drop the procedure and then do a create statement. Is there any way I could say something like...if exists (select * from sysroutines where routine_name = 'procname') then drop procedure procname; ? I tried this, but the proc doesn't like the IF...
Answer Question
| Oct 15 2009 5:32 PM GMTDB2 stored procedures, iSeries DB2, AS/400 stored procedures
