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 physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

0 Answers  

---

YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  

---

Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  

---

What is FORMAT keyword and its use?

0 Answers  

---

what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,

---

---

Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  

---

wirte a simple program for read file in cl

2 Answers   Active Brains,

---

How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  

---

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

3 Answers   HCL,

---

how can we write LF using flatfile.

9 Answers  

---

how to eliminate the level check error

2 Answers   TCS,

---

what is multiple member pf

1 Answers   Active Brains,

---