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

Why we create the Physical File Member?

5 Answers  


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  


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

2 Answers   Active Brains, UHG,


how can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,


what is general and type of general

1 Answers   Active Brains,


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

9 Answers  


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?

9 Answers   Mind Tree, TCS,


What is the batch job?

0 Answers  


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

2 Answers   Four soft,


Last statement of any rpg program is lr?

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  


Categories