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...


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

Answers were Sorted based on User's Feedback



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

Answer / harkesh

IN THIS EXAMPLE I M USING EMPFILE FOR READING IN REVERSE
ORDER.

PGM
DCLF FILE(EMPFILE)
OVRDBF FILE(EMPFILE) SHARE(*YES)
OPNQRYF FILE((EMPFILE)) KEYFLD((EMPNO *DESCEND))

READF: RCVF RCDFMT(MPFILR)
MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END))
GOTO READF



END:
ENDPGM

Is This Answer Correct ?    27 Yes 5 No

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

Answer / ankur

using opnqryf command we can read file in reverse order in CL.

Is This Answer Correct ?    5 Yes 0 No

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

Answer / abhijeet m

OVRDBF FILE(ABC)
MBR(ABC)
POSITION(*END)

RCVF ABC

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More DB400 Interview Questions

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

3 Answers   HCL,


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 with out any data but the dependent LF is having data?

1 Answers   HCL,


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

6 Answers   HSBC,


How to update physical file using logical file with example?

0 Answers  


what is error handling concepts in cl

3 Answers   Active Brains,


How many libraries can be there in a library list?

2 Answers  


how to update physical files using normal logical file

4 Answers  


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

2 Answers   Four soft,


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

9 Answers  


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

3 Answers   Cap Gemini,


Last statement of any rpg program is lr?

0 Answers  


Categories