About AS/400
A file is opened in a program in input mode and he turned the parameter ‘file addition’ to ‘A’. My doubt is, is it possible to add a record to the file thru the program when the file is opened in input mode?
Answer Question
| March 15, 2013 4:00 AM
AS/400, AS/400 Records
A file is opened in a program in input mode and he turned the parameter ‘file addition’ to ‘A’. My doubt is, is it possible to add a record to the file thru the program when the file is opened in input mode?
Answer Question
| March 15, 2013 4:00 AM
AS/400, AS/400 Records
Copying records
Hi, I need to copy file with records from one server to another server. For example, File1 from server1 has 1000records. I need to bring this to server2.
Answer Question
| March 12, 2013 11:19 AM
AS/400, AS/400 Records
Hi, I need to copy file with records from one server to another server. For example, File1 from server1 has 1000records. I need to bring this to server2.
Answer Question
| March 12, 2013 11:19 AM
AS/400, AS/400 Records
Copying records
Hi, I need to copy records from one file (SERVER1) to another file (SERVER2) with same field definitions. It has to be run as a daily job. Please guide me.
Answer Question
| February 5, 2013 12:55 PM
AS/400, AS/400 Records
Hi, I need to copy records from one file (SERVER1) to another file (SERVER2) with same field definitions. It has to be run as a daily job. Please guide me.
Answer Question
| February 5, 2013 12:55 PM
AS/400, AS/400 Records
Chain function to find a specific record
Hi everyone. I need to use CHAIN function to find a specific record. The key is composed from 4 field but I know only two of them. It is possible? Thanks a lot (and sorry for my bad english!! )
Answer Question
| April 11, 2012 11:41 AM
AS/400, AS/400 Records
Hi everyone. I need to use CHAIN function to find a specific record. The key is composed from 4 field but I know only two of them. It is possible? Thanks a lot (and sorry for my bad english!! )
Answer Question
| April 11, 2012 11:41 AM
AS/400, AS/400 Records
AS/400 Query – wild card for LIKE test
When I select records usinf the LIKE test, what wild card character do I use? LIKE ‘air%’?
Answer Question
| March 17, 2012 1:18 AM
AS/400 Query, AS/400 Records
When I select records usinf the LIKE test, what wild card character do I use? LIKE ‘air%’?
Answer Question
| March 17, 2012 1:18 AM
AS/400 Query, AS/400 Records
Read record from multi record format LF using RPGLE
is it possible, read records from multi record format LF using RPGLE. if it is possible, how to do this…
Answer Question
| March 17, 2012 3:05 PM
AS/400 Records, AS400 RPGLE, as400 v5r3
is it possible, read records from multi record format LF using RPGLE. if it is possible, how to do this…
Answer Question
| March 17, 2012 3:05 PM
AS/400 Records, AS400 RPGLE, as400 v5r3
delete hstry
how to delete hstry of a job from log?
Answer Question
| March 6, 2012 5:52 AM
AS/400 Records, as400 log
how to delete hstry of a job from log?
Answer Question
| March 6, 2012 5:52 AM
AS/400 Records, as400 log
AS/400 Scenario
Q. I have a file with millions of records and I want to read the last record from that file.But the conditions are as follows(assume): 1. The file do not have any key field. 2. The file do not give any RRN Number(Assume). 3. We are not allow to use the loop till EOF as [...]
Answer Question
| October 28, 2011 4:33 PM
AS/400, AS/400 Records, RRN
Q. I have a file with millions of records and I want to read the last record from that file.But the conditions are as follows(assume): 1. The file do not have any key field. 2. The file do not give any RRN Number(Assume). 3. We are not allow to use the loop till EOF as [...]
Answer Question
| October 28, 2011 4:33 PM
AS/400, AS/400 Records, RRN
AS400 Query: Date Concatenation
I work for a travel company whose Inventory file uses a unique field for each day of the month, e.g. LGRA1 is the first, LGRA2 is the second etc. The month and the year are single fields. Is there a way of converting these fields to concatenate the date to be able to link easily [...]
Answer Question
| March 31, 2012 9:20 PM
AS/400, AS/400 Query, AS/400 Records, Date concatenation
I work for a travel company whose Inventory file uses a unique field for each day of the month, e.g. LGRA1 is the first, LGRA2 is the second etc. The month and the year are single fields. Is there a way of converting these fields to concatenate the date to be able to link easily [...]
Answer Question
| March 31, 2012 9:20 PM
AS/400, AS/400 Query, AS/400 Records, Date concatenation
Record Locking in SQLRPGLE
Hi All I have a SQLILE pgm which updates files through SQL statements. How to get the user id/job number which is locking the PF record through the program… if any data structure supports, whats the position of it… -Varun
Answer Question
| July 1, 2011 12:35 PM
AS/400 Records, Record lock, RPG Record Locks, SQLRPGLE
Hi All I have a SQLILE pgm which updates files through SQL statements. How to get the user id/job number which is locking the PF record through the program… if any data structure supports, whats the position of it… -Varun
Answer Question
| July 1, 2011 12:35 PM
AS/400 Records, Record lock, RPG Record Locks, SQLRPGLE
Record locking in iSeries
My program takes the input as file, and process those records one by one. Here I would like to add the commitment control, if any one record fails then roll back and continue with the next record. To test this, I need to lock the record in another session and to run the program to [...]
Answer Question
| June 16, 2011 7:38 AM
AS/400, AS/400 Records, Record lock, RPG Record Locks
My program takes the input as file, and process those records one by one. Here I would like to add the commitment control, if any one record fails then roll back and continue with the next record. To test this, I need to lock the record in another session and to run the program to [...]
Answer Question
| June 16, 2011 7:38 AM
AS/400, AS/400 Records, Record lock, RPG Record Locks
SELECT with LIMIT in AS/400
Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT DISTINCT (substring(FILE1, 1, [...]
Answer Question
| June 14, 2011 6:40 PM
AS/400 Parameters, AS/400 Records, SQL, SQL Select
Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT DISTINCT (substring(FILE1, 1, [...]
Answer Question
| June 14, 2011 6:40 PM
AS/400 Parameters, AS/400 Records, SQL, SQL Select
Records limited when downloading from AS400 to Excel
When downloading from AS400 to excel, my records are limited to 16383. I can’t find the place on Iseries FTP Version 5 release 2 to stop it from limiting the records. Please help.
Answer Question
| April 12, 2011 1:53 PM
AS/400, AS/400 Records, Exporting AS/400 to Excel, iSeries FTP
When downloading from AS400 to excel, my records are limited to 16383. I can’t find the place on Iseries FTP Version 5 release 2 to stop it from limiting the records. Please help.
Answer Question
| April 12, 2011 1:53 PM
AS/400, AS/400 Records, Exporting AS/400 to Excel, iSeries FTP
CL/400 OPNQRYF returning empty records.
hey there, I got an issue to be corrected. Current CL has and OPNQRYF select which sometimes return blank records. I need to add a condition which should check for such blank query result and by pass a call program. Can you guys help me in giving a hint on which way I can bypass [...]
Answer Question
| March 25, 2011 12:49 PM
AS/400, AS/400 Records, CL/400, OPNQRYF
hey there, I got an issue to be corrected. Current CL has and OPNQRYF select which sometimes return blank records. I need to add a condition which should check for such blank query result and by pass a call program. Can you guys help me in giving a hint on which way I can bypass [...]
Answer Question
| March 25, 2011 12:49 PM
AS/400, AS/400 Records, CL/400, OPNQRYF
AS/400 Record Count
I need a command to use in a CL program that will give me the record count for all records in a file. RTVMBRD will do it for a single member, but I need it for MBR(*ALL). I know I can dump a *MBRLIST to a file and tally it up form there, but if [...]
Answer Question
| March 1, 2011 7:07 PM
AS/400, AS/400 Records, CL Program, MBR, V5R4
I need a command to use in a CL program that will give me the record count for all records in a file. RTVMBRD will do it for a single member, but I need it for MBR(*ALL). I know I can dump a *MBRLIST to a file and tally it up form there, but if [...]
Answer Question
| March 1, 2011 7:07 PM
AS/400, AS/400 Records, CL Program, MBR, V5R4
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
How to insert records in a physical file using input subfile
have to insert records to a physical file ,the input records should be taken from an input subfile
Answer Question
| January 6, 2011 7:18 AM
AS/400, AS/400 Records, AS/400 Subfiles, COBOL 400, Physical Files
have to insert records to a physical file ,the input records should be taken from an input subfile
Answer Question
| January 6, 2011 7:18 AM
AS/400, AS/400 Records, AS/400 Subfiles, COBOL 400, Physical Files
When using IfNull in my SQL, records are ignored
I know my data table has nulls in it. If my select statement doesn’t include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here’s my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,’ ‘) C+ [...]
Answer Question
| December 24, 2010 12:10 AM
AS/400, AS/400 Records, Data Tables, RPG, SQL
I know my data table has nulls in it. If my select statement doesn’t include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here’s my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,’ ‘) C+ [...]
Answer Question
| December 24, 2010 12:10 AM
AS/400, AS/400 Records, Data Tables, RPG, SQL
Key Mapping Error when writing records in AS/400
When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error
Answer Question
| October 31, 2010 1:03 PM
AS/400, AS/400 error messages, AS/400 errors, AS/400 Records
When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error
Answer Question
| October 31, 2010 1:03 PM
AS/400, AS/400 error messages, AS/400 errors, AS/400 Records
Reading all AS/400 records
i want to read all the records in a file.. and there are no locks on the file during this process.. how will i read the records in fastest possible manner in AS400
Answer Question
| October 21, 2010 10:26 AM
AS/400 File Lock, AS/400 Records, DB2/400
i want to read all the records in a file.. and there are no locks on the file during this process.. how will i read the records in fastest possible manner in AS400
Answer Question
| October 21, 2010 10:26 AM
AS/400 File Lock, AS/400 Records, DB2/400
