Unreadable spool file
Hi all, after I restore some objects on our dev machine using the backup from our prd. I did try to have a copy of the spool file as a report. I use iSeries Navigator to get it from my users spool but when double checking its content its looks like some kind of an [...]
Answer Question
| February 4, 2013 11:48 AM
AS/400, AS/400 Spool Files, iSeries Navigator
Hi all, after I restore some objects on our dev machine using the backup from our prd. I did try to have a copy of the spool file as a report. I use iSeries Navigator to get it from my users spool but when double checking its content its looks like some kind of an [...]
Answer Question
| February 4, 2013 11:48 AM
AS/400, AS/400 Spool Files, iSeries Navigator
Delete 72 hours old record from a file using SQLRPGLE
I have a file containing two fields…First one contains date with century and second one contains time in time stamp format. I want to delete 72 hours old record from this file using SQLRPGLE.
Answer Question
| February 4, 2013 11:09 AM
AS/400, SQLRPGLE
I have a file containing two fields…First one contains date with century and second one contains time in time stamp format. I want to delete 72 hours old record from this file using SQLRPGLE.
Answer Question
| February 4, 2013 11:09 AM
AS/400, SQLRPGLE
See save file in a library
How to see only save file in a library?
Answer Question
| February 4, 2013 10:55 AM
AS/400, AS/400 administration
How to see only save file in a library?
Answer Question
| February 4, 2013 10:55 AM
AS/400, AS/400 administration
Duplicate records in a keyed physical file
Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.
Answer Question
| February 1, 2013 3:06 PM
DDS, Physical File
Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.
Answer Question
| February 1, 2013 3:06 PM
DDS, Physical File
Cursor is returning previous values in SQLRPGLE
I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check [...]
Answer Question
| February 1, 2013 5:10 AM
AS/400, SQLRPGLE
I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check [...]
Answer Question
| February 1, 2013 5:10 AM
AS/400, SQLRPGLE
Outfile for WRKJOB command.
HI All, I need to print all the instance of a job in some spool file or database file. Suppose we have a daily job ABCJOB. Now if I do WRKJOB ABCJOB, it will display all the jobs with date and if I select any, it will show the spool file and other options. Now [...]
Answer Question
| February 1, 2013 9:30 PM
AS/400, AS/400 commands, AS/400 jobs
HI All, I need to print all the instance of a job in some spool file or database file. Suppose we have a daily job ABCJOB. Now if I do WRKJOB ABCJOB, it will display all the jobs with date and if I select any, it will show the spool file and other options. Now [...]
Answer Question
| February 1, 2013 9:30 PM
AS/400, AS/400 commands, AS/400 jobs
Validate date in COBOL/400
I have date in yyyymmdd format. I want to validate if it lies between a particular period of 2 years let b/w 1 Jan 2012 to 5 April 2014, in COBOL/400…. Please help me as the intrinsic function like that in COBOL are not working in this case. Thanks.
Answer Question
| January 31, 2013 7:22 PM
COBOL, COBOL/400
I have date in yyyymmdd format. I want to validate if it lies between a particular period of 2 years let b/w 1 Jan 2012 to 5 April 2014, in COBOL/400…. Please help me as the intrinsic function like that in COBOL are not working in this case. Thanks.
Answer Question
| January 31, 2013 7:22 PM
COBOL, COBOL/400
Examples of AS/400 create alias in Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
QTEMP file not removed
In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I’m [...]
Answer Question
| January 31, 2013 1:23 PM
AS/400, iSeries, QTEMP
In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I’m [...]
Answer Question
| January 31, 2013 1:23 PM
AS/400, iSeries, QTEMP
Certification RPG
Hi, I am planning to do certification in AS/400. I don’t have much coding knowledge. I have been working on support project till date. Can any one please guide me the process, how much is the fee & any suggestions which you would like to mention in specific? Thanks, Sruthi
Answer Question
| January 31, 2013 10:01 AM
AS/400, AS/400 certification
Hi, I am planning to do certification in AS/400. I don’t have much coding knowledge. I have been working on support project till date. Can any one please guide me the process, how much is the fee & any suggestions which you would like to mention in specific? Thanks, Sruthi
Answer Question
| January 31, 2013 10:01 AM
AS/400, AS/400 certification
New record can not be added
We a have ticketing system application but it has stop adding new records. No new message to expand files. Does anyone have any help?
Answer Question
| January 31, 2013 12:30 AM
iSeries, Norwat system
We a have ticketing system application but it has stop adding new records. No new message to expand files. Does anyone have any help?
Answer Question
| January 31, 2013 12:30 AM
iSeries, Norwat system
AS/400 administration
How to know disk space on AS/400?
Answer Question
| January 30, 2013 10:52 AM
AS/400, AS/400 administration
How to know disk space on AS/400?
Answer Question
| January 30, 2013 10:52 AM
AS/400, AS/400 administration
AS/400 administration
how less % system ASP used . . : 90.6553 30/01/13 12:04:42 % CPU used . . . . . . . : 16.5 Auxiliary storage: % DB capability . . . . : 10.2 System ASP . . . . . . : 181.1 G Elapsed time . . . . . . : [...]
Answer Question
| January 30, 2013 10:05 AM
AS/400, AS/400 administration
how less % system ASP used . . : 90.6553 30/01/13 12:04:42 % CPU used . . . . . . . : 16.5 Auxiliary storage: % DB capability . . . . : 10.2 System ASP . . . . . . : 181.1 G Elapsed time . . . . . . : [...]
Answer Question
| January 30, 2013 10:05 AM
AS/400, AS/400 administration
Panasonic CF-H2 Toughbook
I am running Client Access Ver5.5 on a Panasonic CF-H2 Toughbook. When I initiate the built-in scanner on the Toughbook to scan a barcode, the device beeps signifying a good scan, but the Client Access session is not displaying the data. If I initiate the scan on a barcode in note pad, it displays the [...]
Answer Question
| January 30, 2013 9:17 PM
AS/400 Client Access, Client Access
I am running Client Access Ver5.5 on a Panasonic CF-H2 Toughbook. When I initiate the built-in scanner on the Toughbook to scan a barcode, the device beeps signifying a good scan, but the Client Access session is not displaying the data. If I initiate the scan on a barcode in note pad, it displays the [...]
Answer Question
| January 30, 2013 9:17 PM
AS/400 Client Access, Client Access
User profile being disabled
We have one user that is having issues with her profile being disabled. This only happens on Mondays, she signs in once, and it tells her she is disabled. I enable her, only to have this happen again the next Monday. I am not sure how to track this or where to look to correct. [...]
Answer Question
| January 29, 2013 5:02 PM
AS/400, AS/400 user profiles
We have one user that is having issues with her profile being disabled. This only happens on Mondays, she signs in once, and it tells her she is disabled. I enable her, only to have this happen again the next Monday. I am not sure how to track this or where to look to correct. [...]
Answer Question
| January 29, 2013 5:02 PM
AS/400, AS/400 user profiles
RPGLE
I need to change primary and secondary file into full procedure file. Can anybody help me?
Answer Question
| January 29, 2013 2:21 PM
RPGLE, RPGLE files
I need to change primary and secondary file into full procedure file. Can anybody help me?
Answer Question
| January 29, 2013 2:21 PM
RPGLE, RPGLE files
Validate SQL and display the output
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]
Answer Question
| January 29, 2013 8:14 AM
SQL Query, SQL scripts, SQLRPGLE
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]
Answer Question
| January 29, 2013 8:14 AM
SQL Query, SQL scripts, SQLRPGLE
Question is about ILERPG
I have been given a module name and I’m asked to find out the name of the service programs which included that module. Is there any possible way to find it?
Answer Question
| January 29, 2013 7:27 AM
AS/400, AS/400 commands, ILERPG
I have been given a module name and I’m asked to find out the name of the service programs which included that module. Is there any possible way to find it?
Answer Question
| January 29, 2013 7:27 AM
AS/400, AS/400 commands, ILERPG
Single page subfile with filter
I have a single page subfile which has two fields, ‘Account’ and ‘description’. The subfile is displayed from File1 which has account(key) but doesn’t have description. I am fetching description from another file based on the ‘account’. Now in the subfile I want to include a filter or a ‘position to’(any of the one will [...]
Answer Question
| January 29, 2013 7:13 AM
AS/400, AS/400 Subfiles
I have a single page subfile which has two fields, ‘Account’ and ‘description’. The subfile is displayed from File1 which has account(key) but doesn’t have description. I am fetching description from another file based on the ‘account’. Now in the subfile I want to include a filter or a ‘position to’(any of the one will [...]
Answer Question
| January 29, 2013 7:13 AM
AS/400, AS/400 Subfiles
