Interested to Buy Any Domain ? << Click Here >> for more details...
i have 1000 records in pf.what are all the ways to read a
particular name records in rpg?? ie.. in pf i have a name
called demo appeared around 52 times hw will we read this
particular records in rpg/400?.
- 11 Answers
- 21386 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / swetha p rao
If the particular field value is demo , then you can do
onething to avoid reading the file unnecesarily
1. Declare a temporary file in user open mode and specify
as external mbr in F spec.
2. In CPYF there is an option to include records (INCREL )
based on selection, just copy all the records where the
field value is 'demo' in a temporary file with a create
file option. (using QCMDEXC)
3.Now the temporary file will have only demo records.Open
the file and read the records.
(or)
Using SQLRPGLE, write a query to select the records which
has field value 'demo'
Correct me if iam wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is the necessary keyword needed to scroll subfile records?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
How to select highest score of each subject or how to select highest income of every month?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? 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?
How to handle duplicate error handling in RPG?
What is a record lock error?
what is the rpg system?
what is kids-rpg?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
how do you use commitment control in rpg?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
How would display prime numbers using CL program?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
explain sflclr, sflend, sfldlt, and sflcsrrrn?
