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

Define interactive jobs and batch jobs

6 Answers  


what is use of self join and which cases you will use this join

1 Answers   TCS,


How can we handle errors in RPG?

4 Answers  


When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,


how can i know logical file belongs to which physical file without source?

3 Answers   Cap Gemini,






What is the batch job?

0 Answers  


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?

4 Answers   IBM,


Is Constent can be define as a key field?

3 Answers  


In how many ways we can create a logical file?`

5 Answers  


How to update physical file using logical file with example?

0 Answers  


How to know the particular record in pf with out reading?

0 Answers  


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


Categories