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

How to update physical file using logical file with example?

0 Answers  

---

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

2 Answers   Cap Gemini,

---

How to find the list of source physical files in a library?

0 Answers  

---

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  

---

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  

---

Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers   IBM,

---

what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,

---

how to restrict upon adding the data for field reference file in DB400

1 Answers  

---

what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,

---

Why journalling is compulsory before commitment control?

1 Answers  

---

What is the primary file?

0 Answers  

---

what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,

---