How to read data from Nth member of a physical file containing
some X number of members in it?
"Provided member names are unknown"
Answers were Sorted based on User's Feedback
Answer / sandey243
Way:1
We can execute DSPFD with *OUTFILE option, using QCMDEXC in
RPGLE program then we can read the outfile to get the name
of the file, then after we can read the file.
Way2:
Make the file to have all members available i.e.,
EXTMBR(*ALL). Then move *HIVAL to RRN and do a SETGT on the
file... this will take the control to the bottom of the
first member...then READ will give you first record of the
Second member...... This way we can go to the member....
(This method I tried and succeeded)...
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / zavith ahamed
to declare f spec extmbr(*all) to read the data from file
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sakshi bansal
I tthink we can use OVRDBF command in Cl and call RPG through it.
| Is This Answer Correct ? | 0 Yes | 5 No |
1)how to do date validation in rpg? 2)how to delete dUPLICATE RECORDS?
Difference between creating a report using Printer file and WRKQRY(Query Report) ?
can I touch the array during treatments?
Hi friends, I am using a load all subfile , and currently i am in in the third page of the subfile , from third page i have selected a record and called some other program .on returning, subfile is being loaded from the frist page. so can any one kindly suggest me in retaining my third page after returning. i.e loading from third page.
What is file identifier where we can use?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)
Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?
Need a sql query: retrive all duplicate records in table
What is the difference between copybooks and subprocedures in as400?
where we give the MSGSFL in rpg400?
how many variables can we declare in cl pgm?