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.

Answer / gowrishankar.m

using cpyf Starting position as 11

or

using CHAIN in key field giv relative record number

Answer / anup

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

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

0 Answers  

---

How to retrieve a physical file after deleting that?

0 Answers  

---

When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

0 Answers  

---

how can we write LF using flatfile.

9 Answers  

---

When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  

---

How we can't update join logical files?

10 Answers  

---

How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 Answers  

---

hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that

9 Answers   Encore,

---

i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  

---

How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,

---

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

3 Answers   Cap Gemini,

---

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

4 Answers   Cap Gemini,

---