PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Physical Files

View previous topic View next topic Go down

Physical Files

Post  abilash on Sat Oct 09, 2010 3:32 pm

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

abilash

Posts : 7
Join date : 2010-10-09

View user profile

Back to top Go down

Re: Physical Files

Post  Kavithaa on Sat Oct 09, 2010 3:34 pm

using cpyf Starting position as 11

or

using CHAIN in key field give relative record number

Kavithaa

Posts : 5
Join date : 2010-10-09

View user profile

Back to top Go down

Re: Physical Files

Post  sivakumar on Sat Oct 09, 2010 3:35 pm

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.

sivakumar

Posts : 174
Join date : 2009-07-27
Age : 30
Location : Chennai

View user profile

Back to top Go down

Re: Physical Files

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum