Subfile sort
I have a subfile program for updating, creating, and displaying item information the user can select from to create, view or update detail. The subfile shows item number, description, etc from my main file (i’ll call itemnum1)and a vendor item number from an auxiliary file (itemnum2). My question is the users want to be able [...]
Answer Question
| April 8, 2011 8:08 PM
SQL Subfile, Subfile
I have a subfile program for updating, creating, and displaying item information the user can select from to create, view or update detail. The subfile shows item number, description, etc from my main file (i’ll call itemnum1)and a vendor item number from an auxiliary file (itemnum2). My question is the users want to be able [...]
Answer Question
| April 8, 2011 8:08 PM
SQL Subfile, Subfile
Need help using excel to amend ibm reflections
Hi, I have been tasked with updating a database using IBM Reflections for 1600+ entries. I have been doing it by hand so far and have seen threads but never gotten enough info out of them. What I want to do, which I would do if it were two excel files, is update the database [...]
Answer Question
| February 24, 2011 4:39 PM
AS/400, excel, IBM Reflections
Hi, I have been tasked with updating a database using IBM Reflections for 1600+ entries. I have been doing it by hand so far and have seen threads but never gotten enough info out of them. What I want to do, which I would do if it were two excel files, is update the database [...]
Answer Question
| February 24, 2011 4:39 PM
AS/400, excel, IBM Reflections
AS400 – ZIPPING
hi i have a CSV file in my IFS folder.with size of 5GB.When iam zipping that file with Jar command.it is throwing me the error. java.io.FileNotFoundException: Object is too large to process. /arcbi/pomalw_ php_22022011.csv java/lang/Throwable.[Init](Ljava/lang/String;)V+4 (Throwable.java:90) java/io/FileInputStream.[Init](Ljava/lang/String;)V+28 (FileInputStream .java:64) sun/tools/jar/Main.run([Ljava/lang/String;)Z+107 (Main.java:124) sun/tools/jar/Main.main([Ljava/lang/String;)V+17 (Main.java:904). I feel zipping is not happening because sie of file is more.when [...]
Answer Question
| February 28, 2011 5:41 AM
AS/400, AS/400 Compression, File compression
hi i have a CSV file in my IFS folder.with size of 5GB.When iam zipping that file with Jar command.it is throwing me the error. java.io.FileNotFoundException: Object is too large to process. /arcbi/pomalw_ php_22022011.csv java/lang/Throwable.[Init](Ljava/lang/String;)V+4 (Throwable.java:90) java/io/FileInputStream.[Init](Ljava/lang/String;)V+28 (FileInputStream .java:64) sun/tools/jar/Main.run([Ljava/lang/String;)Z+107 (Main.java:124) sun/tools/jar/Main.main([Ljava/lang/String;)V+17 (Main.java:904). I feel zipping is not happening because sie of file is more.when [...]
Answer Question
| February 28, 2011 5:41 AM
AS/400, AS/400 Compression, File compression
CPF5423 in ISDB debugging service job
when debugging a COBOL service job, I sometimes get CPF5423 in the debugging session. I am using Client Access Version 6.0 20091022 S. This has happened with at least 2 versions of Client Access and at least 2 OS releases. It only happens if I hit the F5 key before the debug source screen reappears. [...]
Answer Question
| June 15, 2012 9:51 PM
AS/400 Client Access, Client Access 6.0, Client Access 6.x, iSeries, V5R4M5
when debugging a COBOL service job, I sometimes get CPF5423 in the debugging session. I am using Client Access Version 6.0 20091022 S. This has happened with at least 2 versions of Client Access and at least 2 OS releases. It only happens if I hit the F5 key before the debug source screen reappears. [...]
Answer Question
| June 15, 2012 9:51 PM
AS/400 Client Access, Client Access 6.0, Client Access 6.x, iSeries, V5R4M5
Open IT Forum: What cloud concern do you need addressed?
Will all of the buzz surrounding the cloud – no doubt amplified by Vivek Kundra’s push to the cloud – are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know about [...]
Answer Question
| December 30, 2011 8:23 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Will all of the buzz surrounding the cloud – no doubt amplified by Vivek Kundra’s push to the cloud – are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know about [...]
Answer Question
| December 30, 2011 8:23 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
V5R4 download 5722UME
I need to download 5722UME for OS V5R4 (I don’t have the CD’s). Does anyone know the IBM URL I can get this from?
Answer Question
| February 24, 2011 1:20 PM
AS/400 administration, AS/400 applications, V5R4
I need to download 5722UME for OS V5R4 (I don’t have the CD’s). Does anyone know the IBM URL I can get this from?
Answer Question
| February 24, 2011 1:20 PM
AS/400 administration, AS/400 applications, V5R4
How to start *admin in HTTP Server.
It has been scheduled to start STRTCPSVR but in HTTP the *ADMIN is not started. Only the default Apache is active. HTTP server unable to start. Initialization errors were detected. Failed to bind and listen on port 80. HTTP server unable to start. Configuration errors were detected. HTTP Server instance APACHEDFT is already active.
Answer Question
| March 16, 2011 11:42 AM
HTTP, STRTCPSVR, V5R1
It has been scheduled to start STRTCPSVR but in HTTP the *ADMIN is not started. Only the default Apache is active. HTTP server unable to start. Initialization errors were detected. Failed to bind and listen on port 80. HTTP server unable to start. Configuration errors were detected. HTTP Server instance APACHEDFT is already active.
Answer Question
| March 16, 2011 11:42 AM
HTTP, STRTCPSVR, V5R1
Handling errors in CL Programs
I’ve been searching all over the internet (and this site) looking for a good way to generically handle errors within a CL program. Everything’s seems very vauge to me. What I’m looking to do is something like this: CHGSPLFA FILE(&SPOOLFILE) SAVE(*NO) MONMSG MSGID(CPF0000) EXEC('SEND EMAIL WITH ERROR MESSAGE DETAILS TO A USER AND EXIT PROGRAM') [...]
Answer Question
| February 23, 2011 9:10 PM
CL Program, Control Language Programming, ILE Program, iSeries
I’ve been searching all over the internet (and this site) looking for a good way to generically handle errors within a CL program. Everything’s seems very vauge to me. What I’m looking to do is something like this: CHGSPLFA FILE(&SPOOLFILE) SAVE(*NO) MONMSG MSGID(CPF0000) EXEC('SEND EMAIL WITH ERROR MESSAGE DETAILS TO A USER AND EXIT PROGRAM') [...]
Answer Question
| February 23, 2011 9:10 PM
CL Program, Control Language Programming, ILE Program, iSeries
AS400 JOBCTL
What are the security issues regarding giving JOBCTL to a User?
Answer Question
| March 16, 2011 4:48 PM
AS/400, AS/400 security, AS/400 Security Levels, JOBCTL
What are the security issues regarding giving JOBCTL to a User?
Answer Question
| March 16, 2011 4:48 PM
AS/400, AS/400 security, AS/400 Security Levels, JOBCTL
Free IT Book: The RAILS 3 Way
It’s been called “The Bible for Ruby on Rails Application Development.” To get your copy of the book that “strips complexity from the development process,” answer one of five questions and post the link to your answer in the discussion section below. Recovering Oracle 10g Express data SQL 2000 database recovery How to connect Oracle [...]
Answer Question
| September 27, 2011 2:34 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s been called “The Bible for Ruby on Rails Application Development.” To get your copy of the book that “strips complexity from the development process,” answer one of five questions and post the link to your answer in the discussion section below. Recovering Oracle 10g Express data SQL 2000 database recovery How to connect Oracle [...]
Answer Question
| September 27, 2011 2:34 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
AS400 – File
I wanted to do Chain Kfld File1 If Found And Fld1 = ‘Y’ Update File Else Perform Next Chain Operation Endif Here I wanted to perform the Chain without Locking the Record. I wanted to perform Update Operation without Performing Read/Chain again if the Condition is True. How to achieve this?
Answer Question
| February 26, 2011 2:05 PM
AS/400 Records, AS400- File, Record lock, RPG Record Locks
I wanted to do Chain Kfld File1 If Found And Fld1 = ‘Y’ Update File Else Perform Next Chain Operation Endif Here I wanted to perform the Chain without Locking the Record. I wanted to perform Update Operation without Performing Read/Chain again if the Condition is True. How to achieve this?
Answer Question
| February 26, 2011 2:05 PM
AS/400 Records, AS400- File, Record lock, RPG Record Locks
AS400 – COPYBOOK
I have changed Copy Book which is used in two programs. I have defined the Copybook Using /COPY LIBRARY/QRPGLESRC CPYBK1. Is there any possiblity to change Library and Source Physical File Name Dynamically?
Answer Question
| February 23, 2011 1:58 PM
AS/400 Library, AS400 - Copy Book, QRPGLESRC
I have changed Copy Book which is used in two programs. I have defined the Copybook Using /COPY LIBRARY/QRPGLESRC CPYBK1. Is there any possiblity to change Library and Source Physical File Name Dynamically?
Answer Question
| February 23, 2011 1:58 PM
AS/400 Library, AS400 - Copy Book, QRPGLESRC
AS400 Flat file data comparison on Window based third party tool like Examdiff Pro
My system gets data in flat file for booking.Once the booking is completed , customer sends some corrections data in other flat file. I have to compare both flat files data in window based comparison tool like EXamdiff Pro . if sent correction notes is ok, then update the physical files. example Original flat file [...]
Answer Question
| February 28, 2011 11:07 AM
AS/400 Data File, AS/400 Data Reports, AS/400 flat file
My system gets data in flat file for booking.Once the booking is completed , customer sends some corrections data in other flat file. I have to compare both flat files data in window based comparison tool like EXamdiff Pro . if sent correction notes is ok, then update the physical files. example Original flat file [...]
Answer Question
| February 28, 2011 11:07 AM
AS/400 Data File, AS/400 Data Reports, AS/400 flat file
Find AS/400 string
hi all my requirement is find out string that which object contain,that object name,type,libery name,source file name.find all data and store this data into one physical file. physical file contain fields R rec objname 10A objType 10A Libraryname 10A source-pf 10A Ex:-my string is empdetails this string scan all the objects [...]
Answer Question
| February 22, 2011 5:49 PM
AS/400, AS400 physical file, Physical Files, String testing
hi all my requirement is find out string that which object contain,that object name,type,libery name,source file name.find all data and store this data into one physical file. physical file contain fields R rec objname 10A objType 10A Libraryname 10A source-pf 10A Ex:-my string is empdetails this string scan all the objects [...]
Answer Question
| February 22, 2011 5:49 PM
AS/400, AS400 physical file, Physical Files, String testing
Mouse & button use in Window subfile
i want create a window subfile, i want use the button for back and next page(program) not use any key like F1, F2 or F12 only button use for any action and i want select the subfile record by the mouse not by any keyboard key like page up or page down, only by mouse [...]
Answer Question
| February 21, 2011 5:38 PM
AS/400 Subfiles, Subfile, Subfile Record Format
i want create a window subfile, i want use the button for back and next page(program) not use any key like F1, F2 or F12 only button use for any action and i want select the subfile record by the mouse not by any keyboard key like page up or page down, only by mouse [...]
Answer Question
| February 21, 2011 5:38 PM
AS/400 Subfiles, Subfile, Subfile Record Format
Transfering (save/restore) job scheduler from one AS400 to another
Other than a SAVSYS, which I believe saves the native job scheduler which can subsequently be restored, is there a way to simply save and then restore (on a different AS400) all the entries on the job scheduler on their own?
Answer Question
| March 13, 2011 8:13 AM
AS/400, AS/400 job scheduler, JOB SCHEDULER, SAVSYS
Other than a SAVSYS, which I believe saves the native job scheduler which can subsequently be restored, is there a way to simply save and then restore (on a different AS400) all the entries on the job scheduler on their own?
Answer Question
| March 13, 2011 8:13 AM
AS/400, AS/400 job scheduler, JOB SCHEDULER, SAVSYS
Use of ‘THRU’ in cobol ?
Hi. i have 2 questions in cobol : 1) Suppose i have a para : 1000-process Now while processing if i use : perform 1000-process thru 1000-exitand perform 1000-process .What will be the difference. 2) Suppose there is a cobol pgm named ABC .and in indentification division, i i give the name XYZ.Then i call [...]
Answer Question
| February 22, 2011 7:00 AM
AS/400, COBOL, COBOL Programs, COBOL statements
Hi. i have 2 questions in cobol : 1) Suppose i have a para : 1000-process Now while processing if i use : perform 1000-process thru 1000-exitand perform 1000-process .What will be the difference. 2) Suppose there is a cobol pgm named ABC .and in indentification division, i i give the name XYZ.Then i call [...]
Answer Question
| February 22, 2011 7:00 AM
AS/400, COBOL, COBOL Programs, COBOL statements
Comment the compile time values in AS/400
HI, I am using compile time array. I NEED TO COMMENT THE VALUES SPECIFIED which i specified after ** i can able to comment E spec but the values i cant….
Answer Question
| April 2, 2012 7:49 AM
AS/400 administration, AS/400 command functions, AS/400 compile
HI, I am using compile time array. I NEED TO COMMENT THE VALUES SPECIFIED which i specified after ** i can able to comment E spec but the values i cant….
Answer Question
| April 2, 2012 7:49 AM
AS/400 administration, AS/400 command functions, AS/400 compile
Sort a table in COBOL on the Output Side
Warning: I have limited knowledge of tables! I have a COBOL program that calculates GPAs on the fly in the OUTPUT section of the program. I have to store these on-the-fly GPAs in a table, and then sort them by school, grade level, GPA total, then student id. I can load my table, but I am not sorting [...]
Answer Question
| March 2, 2011 9:38 PM
COBOL, COBOL Programs, ILE COBOL, iSeries Cobol programming
Warning: I have limited knowledge of tables! I have a COBOL program that calculates GPAs on the fly in the OUTPUT section of the program. I have to store these on-the-fly GPAs in a table, and then sort them by school, grade level, GPA total, then student id. I can load my table, but I am not sorting [...]
Answer Question
| March 2, 2011 9:38 PM
COBOL, COBOL Programs, ILE COBOL, iSeries Cobol programming
SFTP in batch mode
Hi How can we perform SFTP in batch mode? Is it possible to perform SFTP without using public and private keys? It would be of great help if provided some sample code to refer also. Thanks, Vivek
Answer Question
| February 18, 2011 2:31 PM
AS/400, AS/400 SFTP, RPG Batch Mode, SFTP
Hi How can we perform SFTP in batch mode? Is it possible to perform SFTP without using public and private keys? It would be of great help if provided some sample code to refer also. Thanks, Vivek
Answer Question
| February 18, 2011 2:31 PM
AS/400, AS/400 SFTP, RPG Batch Mode, SFTP
