How to read alternative records in a pf by using rpg?
Answers were Sorted based on User's Feedback
Answer / uday bagdi
we can create the pre-run time array so that data-base file come in our rpg program then we read that pre-run time array with loop and increment the array indexing by 2
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / uday bagdai
1st set the pointer on the record(depend on rrn).after increase the rrn value by 2 (rrn=rrn+2).trape their on doweq loop so you can read alternative records.because (your pointer set on alternative records)
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / abhishek
The first method is not very full proof. Actually it is not
necessary that RRN is always sequential.
Suppose initally there are 100 records in a file and so
does the RRN starts from 1 for first record and 100 for
last record.
If 1 record is deleted from the file RRN remains unchaned
and in that case adding 2 may cause a problem if system
does not get Record at that RRN it will read the next
sequential.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sreedhar reddy
Simple way is just read a PF process 1st record, then for second read ignore it. It is simple like having two read operations, first is at start of the loop and second is at just before end of the loop.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mahalakshmi
All the records in a file is first loaded in to an datastructure and then incrementing the value of datastructure +2 then read the values in the datastructure.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramu
how to fetch alternate records from data base(pf) using RPG? (ex. 1st and 3rd and 5th .......etc)
I need Rpg code not theory?
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
sample code for alternative record in a pf
fsamplepfif e disk
/free
dow not %eof(samplepf);
read samplepf;
If %eof(samplepf);
Leave;
endif;
---------;(doing some actions based on the conditions)
read samplepf;
enddo;
*inlr = *on;
/end-free
Is This Answer Correct ? | 1 Yes | 6 No |
Hi, can any one tell me :IN CASE OF SINGLE PAGE FILE HOW WILL I LOAD THE PREVIOUS PAGE WITHOUT THE USE OF SFLCLR INDICATOR ?
Explain mdt?
How would display prime numbers using CL program?
How can you delete a record from a file in RPG without using DELETE oppcode?
What are the types of identifiers?
When a object will be locked & when a record will be locked? Plz explain.
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
Hi, Can anybody give me real sinario for SFLRCDNBR?with example?
without logical file we cannot access the data in physical file.but we specify physical file in the program(ie:- Ffile IF E k disk).how can it be accessed?
Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?
how do u find whether a record is locked or not??/
Can we found a record existance in a file w/o reading the file?
6 Answers Traitsys Technologies,