A pf containing 100 records... my query is how to display
from 11th record in the pf?

Answers were Sorted based on User's Feedback



A pf containing 100 records... my query is how to display from 11th record in the pf?..

Answer / keshar jain

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.

Is This Answer Correct ?    16 Yes 1 No

A pf containing 100 records... my query is how to display from 11th record in the pf?..

Answer / gowrishankar.m

using cpyf Starting position as 11

or

using CHAIN in key field giv relative record number

Is This Answer Correct ?    8 Yes 3 No

A pf containing 100 records... my query is how to display from 11th record in the pf?..

Answer / anup

Select * from pfname where rrn(pfname) >= 11

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB400 Interview Questions

I have a pf, it contains 5 members, how to access particular member data from logical file?

0 Answers  


CRTDTA AND CRTARA should be used along with?

2 Answers  


How many max. Record format a logical file have?

13 Answers   Systime,


How to index LF by relative record no (RRN)

0 Answers  


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,


pls anyone explain about compile time array,pre run time array run time array

4 Answers  


what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,


What is the interactive job?

0 Answers  


How we can't update join logical files?

10 Answers  


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


How can we handle errors in RPG?

4 Answers  


Categories