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 |
I have a RPG program of 100 Lines and first line is to SETON indicator LR. Will the program execute rest of the 99 Lines?
How do you call procedures in ILE?
Job is in MSGW while reading the input file and writing a new record / updating a reacod due to Duplicate data error. What action would you take ( C D I R )...?
What will be the value of STRING after line 0106 is executed in the code below? 0101 E* Fromfiletofile..tabnameprnentlenpdatabnamlenpda 0102 E ARR 8 1 0103 ISTRING DS 0104 I 1 8 ARR 0105 C MOVE *BLANK STRING 0106 C MOVEA'ABC' ARR A) 'AAAAAAAA' B) 'BBBBBBBB' C) 'CCCCCCCC' D) 'ABC ' E) ' ABC'
Why we need to give File and To file Names While we are using OVRDBF. What is your understanding related to this?
1. I have2 records in a PF. READ PF DO DSPLY EMPNO RETRN DSPLY EMPNO ENDDO What was the output 2. SETON LR vs RETURN 3. Primary File 4. How to delete a deleted spaces 5. How to read a PF in reverse order in CL 6. I have a object in Lib A, B and C. But it shows in D Lib..Why? 7.
Can somebody tell me that, Is it possible to read all the member of PF without OVRDBF?
this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002
can anyone explain aboutovrOVRDBF,OPNQRYF, OVRSCOPE and OPNSCOPE?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
I know chain keyword retreive records randomly but how chain keyword exactly works internally????
How to sort an array in descending in RPG