IBM DB400 Question:
Download Questions PDF

How to read a PF in reverse(from last rec to first) using CL?

Answer:

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

Download IBM DB400 Interview Questions And Answers PDF

Previous QuestionNext Question
How to retrieve a physical file after deleting that? What is keyword used for that?Suppose 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?