Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


A pf containing 100 records... my query is how to display
from 11th record in the pf?

Answers were Sorted based on User's Feedback



A pf containing 100 records... my query is how to display from 11th record in the pf?..

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.

Is This Answer Correct ?    16 Yes 1 No

A pf containing 100 records... my query is how to display from 11th record in the pf?..

Answer / gowrishankar.m

using cpyf Starting position as 11

or

using CHAIN in key field giv relative record number

Is This Answer Correct ?    8 Yes 3 No

A pf containing 100 records... my query is how to display from 11th record in the pf?..

Answer / anup

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

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB400 Interview Questions

Last statement of any rpg program is lr?

0 Answers  


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

1 Answers   TCS,


Why journalling is compulsory before commitment control?

1 Answers  


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

0 Answers  


There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers  


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


what is exception and how many types of exception

1 Answers   Active Brains,


What is the purpose of the chain and setll and setgt?

0 Answers  


Last statement of any RPG pgm is LR?

5 Answers  


how can we write LF using flatfile.

9 Answers  


How many libraries can be there in a library list?

2 Answers  


Categories