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
- 17812 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
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?
what are the key words you must use when using a subfile?
what is *place and *auto keyword in prtf ?plz explain
Interviewer asked me write down DDS for load all subfile .can anybody write dds
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
How Chain operation copies the record's data to the input buffer for the 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.
what is a rpg?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
What is ment by record level identifier?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
What is the purpose of record level identifier?
what is file information data structure?
