How can we search particular records from the database file
in RPG.
For example, there are
100 records in the file.i need to retrieve all the records
matching/equal to the particular 'NAME' field. How can we
do the above using SEARCH criteria other than using the IF
cond?
Answer Posted / maddy
This can be done using the Key Field.
KEY1(NAME FIELD) SETLL FILENAME
KEY1(NAME FILED) READE FILENAME
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How to handle duplicate error handling in RPG?
How can we override a file during runtime in rpg?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
What is a record lock error?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
How many program bind in one module....
Interviewer asked me write down DDS for load all subfile .can anybody write dds
What is the difference between copybooks and subprocedures in as400?
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?
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...?
Explain mdt?
what is program status data structure?
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
what are the key words you must use when using a subfile?