How can read PF in reverse order (end to start) in CL pgm..

Answers were Sorted based on User's Feedback



How can read PF in reverse order (end to start) in CL pgm....

Answer / shyam

Use OVRDBF Share(*yes)
Use the Openqry file by specified the values on opnqry file

Key field . . . . . . . . . . *NONE
Key field order . . . . . . . *DESCEND

now read file using RCVF command.

Is This Answer Correct ?    26 Yes 11 No

How can read PF in reverse order (end to start) in CL pgm....

Answer / kavitha

POSDBF (*END) points to last record, wont the RCVF command sets on EOF indicator?

Is This Answer Correct ?    11 Yes 7 No

How can read PF in reverse order (end to start) in CL pgm....

Answer / harkesh

you can read a physical file in DESENDING ORDER. You can
first sort the physical file in decending order through
OPNQRYF using KEYFLD. This will sort your PF in decending
order based on your key field and then do the RCVF on this
file.
But for this you first need to do OVRDBF on the file.

THIS IS ONLY THE WAY ON THE WE CAN READ PF IN REVERSE ORDER
BUT FOR THIS FILE SHOULD BE KEYED FILE.
ANOTHER WAY FOR THIS ON THE BASIS OF RRN. FIRST FIND OUT
TOTAL NO OF RECORD USING RTVMBRDSC COMMMAND IN CL PROGRAM.
THEN MOVE TOTAL NO TO RRN. THEN BY USING OVRDBF COMMAND SET
POINTER ON THE BASIS OF RRN. AND IN LOOP ON THE BASIS OF
RRN. LIKE
LOOP: OVERDBF FILENAME POINTER = &RRN
IF RRN NOT = 0
RCVF RCDFMTNAME.

RRN= RRN-1.

ELSE
ENDPGM
END-IF.

Is This Answer Correct ?    5 Yes 2 No

How can read PF in reverse order (end to start) in CL pgm....

Answer / sai

Use OVRDBF Share(*yes)
Use the Openqry file by specified the values on opnqry file

Key field . . . . . . . . . . Key Field name
Key field order . . . . . . . *DESCEND

Is This Answer Correct ?    3 Yes 0 No

How can read PF in reverse order (end to start) in CL pgm....

Answer / sumit gupta

We can not read a pf in reverse order in CL/CLLE. As POSDBF
only set the pointer to *START or *END and once you set it
to *END and then do the read operation, end of file will
reach and there is not such condition(MONMSG) through which
you can read the pf in reverse order.

you can read a physical file in DESENDING ORDER. You can
first sort the physical file in decending order through
OPNQRYF using KEYFLD. This will sort your PF in decending
order based on your key field and then do the RCVF on this
file.
But for this you first need to do OVRDBF on the file.

Is This Answer Correct ?    9 Yes 7 No

How can read PF in reverse order (end to start) in CL pgm....

Answer / suresh

Since the requirement is to Read from end to start, the
parameter *END should be provided to Position.

The statement should look like:

POSDBF OPNID(file name) position(*END)

Is This Answer Correct ?    16 Yes 15 No

How can read PF in reverse order (end to start) in CL pgm....

Answer / amit

See Opnqryf is the right answer. Use the keyfield as told
by others. But it is not necessary to overide the file.

Is This Answer Correct ?    0 Yes 0 No

How can read PF in reverse order (end to start) in CL pgm....

Answer / sajied

use posdbf opnid(file name)
position (*start)

Is This Answer Correct ?    4 Yes 26 No

Post New Answer

More RPG400 Interview Questions

We have a Physical file, after reading 5 records,it has to read LF of that same Physical file,Will it start reading from Ist record or will start reading from 5th record?

5 Answers   Hexaware,


We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

0 Answers  


two attributes which govern the excecution of a job>>>>??

2 Answers   CTS,


1) How to retrieve RRN through RPG ? 2) How to pass parameter by value ? 3) How to trap the error through the RPG/400

10 Answers   IBM, Tech Mahindra,


How do you know if a record exists without doing a READ and CHAIN?

6 Answers   IBM,






i want to retrieve record b/w 2 dates in as400

2 Answers   L&T,


The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers  


What are the necessary keywords required to code a message subfile?

3 Answers  


If record-format name in an externally-described file has already been defined as a file-name.how to solve this?

2 Answers   CTS,


what is kids-rpg?

0 Answers   IBM,


is this a rpg channel?

0 Answers   IBM,


i have a file with the values 10, 20, 30, 40, if am setll with the value 25 then readp, so what it will return?

6 Answers   Mind Tree,


Categories