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 ?and what is the use of member in PF

3 Answers  

---

how to update physical file using logucal file with example

1 Answers   Wipro,

---

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

1 Answers   TCS,

---

How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,

---

pls anyone explain about compile time array,pre run time array run time array

4 Answers  

---

In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,

---

What is open data path? And what is the difference between access path and open data path?

1 Answers  

---

what is error handling concepts in cl

3 Answers   Active Brains,

---

How many maximum record format a logical file have?

0 Answers  

---

How we can't update join logical files?

10 Answers  

---

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

1 Answers  

---

what is the purpus of the chain and setll and setgt ?

2 Answers   Four soft,

---