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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Physical Files

3 posters

Go down

Physical Files Empty Physical Files

Post  abilash 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

Back to top Go down

Physical Files Empty Re: Physical Files

Post  Kavithaa 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

Back to top Go down

Physical Files Empty Re: Physical Files

Post  sivakumar 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 : 37
Location : Chennai

Back to top Go down

Physical Files Empty Re: Physical Files

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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