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

1.String operatio such as moving the characters to the variables? 2.what are the building functions for check file longs? 3.which of the following methods will make externally describe file fields available to a program? A: A/copy statement that specifies the library file and member of the field reference file source code B: A data structure definition specification that names the file on the EXTNAME keyword C: A data structure definition specification that names the file on the IMPORT keyword? D: A Definition specification for each desired field with the REFFLD keyword

1 Answers   CSC, CTS,


2. Which of the following statement(s) explains the difference(s) between the /INCLUDE and ICOPY directives? a.) No difference, they function the same b.) ACOPY cannot be used as a conditional directive c.) IINCLUDE files cannot contain embedded SQL d.) Nesting /TNCLUDE directives is not allowed

2 Answers   IBM,


1) How to declare a file? 2) How to define a display file? 3) How to monitor error messages in RPG? 4) How to find the attributes for subfiles? and what is the DDS for subfiles?

2 Answers   TCS,


What is the purpose of FRCDTA keyword?

3 Answers   IBM,


what is use of sflnxtchg and use of MDT(modify data tag).both r same r not and can we use these on dspf and subfile.

2 Answers  


1.I Have a physical file , i want to read the data from the each and every member of the File in the CL Program.How do you achieve this. 2.How do you do the same in RPG?. do think is it possible to read data from all the members in the RPG?

2 Answers   Cap Gemini,


Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg

0 Answers  


check existence of one record without using chain or read?

1 Answers   IBM,


1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

6 Answers   Virtusa,


what is the equivalent keyword for CHAIN opcode ??

7 Answers   TCS,


How to read a record from file where there is multiple record occurrence is available?

1 Answers  


What is the purpose of Panel Groups?

4 Answers  


Categories