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
- 20969 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
How to select highest score of each subject or how to select highest income of every month?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
what is a rpg?
what is data area and how it is used in rpg program ?
How to call one program from another program in RPG? please help me with the code
can I touch the array during treatments?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
how does the rpg element work?
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?
what is the use of sflnxtchg?
What is the difference between copybooks and subprocedures in as400?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
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
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
