How to read a PF in reverse(from last rec to first) using CL?
- 3 Answers
- 11829 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harkesh
IN THIS EXAMPLE I M USING EMPFILE FOR READING IN REVERSE
ORDER.
PGM
DCLF FILE(EMPFILE)
OVRDBF FILE(EMPFILE) SHARE(*YES)
OPNQRYF FILE((EMPFILE)) KEYFLD((EMPNO *DESCEND))
READF: RCVF RCDFMT(MPFILR)
MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END))
GOTO READF
END:
ENDPGM
| Is This Answer Correct ? | 27 Yes | 5 No |
Answer / ankur
using opnqryf command we can read file in reverse order in CL.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / abhijeet m
OVRDBF FILE(ABC)
MBR(ABC)
POSITION(*END)
RCVF ABC
| Is This Answer Correct ? | 1 Yes | 10 No |
If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.
A pf containing 100 records... my query is how to display from 11th record in the pf?
How to know the perticular record in pf with out reading?
pls anyone explain about compile time array,pre run time array run time array
How to change the batch job to interactive job?
Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...
How to know logical file belongs to which physical file without source?
how to update physical files using normal logical file
Last statement of any rpg program is lr?
Why journalling is compulsory before commitment control?
Maximum how many fields we can create under a record format of PF?
Q.1 how to implement the commitment control. 2.how to control commitment control from external program.
RPG400 
