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
Interviewer asked me write down DDS for load all subfile .can anybody write dds
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...........
write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen
What is ment by record level identifier?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
what is *place and *auto keyword in prtf ?plz explain
is this a rpg channel?
how can I tell when to replace the array?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
What is a record lock error?
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.
What is difference between bind by copy and bind by reference?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
what is file information data structure?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?