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 |
Are all these RPG/400 Interviewed Questions being asked recently? are current?
1.How you will find the program is batch or online in cl pgm? 2.How you will end the batch pgm when the job runs? write an logic? 3.In wich command the option *drop is used?
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)
Hi guys. Im in AS/400(RPGLE,CLP) from last 1 year.Now i wan to upgrade my Knowledge in AS/400. Suggest me some new fields & courses which falls under AS/400. Waiting for your quick Response.
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
Interviewer asked me write down DDS for load all subfile .can anybody write dds
Delete FileName at first statement in RPG.
As Packed veriable store 2 digits in 1 byte and ZONE variable store 1 digit in 1 byte... Please tell me when we have to use Packed and Zone variable...?
How can we call CL program to RPG? How many number of parameter we can pass
what is difference between DSPFD and DSPFFD?please give me real senario with good example?
purpose of pannel group??/
how to display all the members records in a physical file without using ovrdbf?