Interested to Buy Any Domain ? << Click Here >> for more details...
How to read a PF in reverse(from last rec to first) using CL?
- 3 Answers
- 12973 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 |
How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?
how to restrict upon adding the data for field reference file in DB400
How to add a field to a PF and compile it without loss of data?
Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?
How we can't update join logical files?
What is open data path?
How to know logical file belongs to which physical file without source?
how to know total no of records in pf with out using sql??????
Q.1 how to implement the commitment control. 2.how to control commitment control from external program.
i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF
Last statement of any RPG pgm is LR?
Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?
RPG400 
