IBM DB400 Question: Download Questions PDF
A pf containing 100 records... my query is how to display from 11th record in the pf?
Answer:
We can positioned to nth record in file in CL with the help of OVRDBF command.
Synatax:
OVRDBF FILE(file-name) POSITION(*RRN 11)
This will positioned file on 11th record so RCVF command will read 11th record in file.
If you want to read with key conditioned then we can specify *KEY,*KEYA,KEYAE etc to positioned with key specified in command.
Synatax:
OVRDBF FILE(file-name) POSITION(*RRN 11)
This will positioned file on 11th record so RCVF command will read 11th record in file.
If you want to read with key conditioned then we can specify *KEY,*KEYA,KEYAE etc to positioned with key specified in command.
Download IBM DB400 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| I had created one physical file tell me command to enter data in to? | What is the purpose of the chain and setll and setgt? |