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 / prabhakar

This can be done using SETLL and READE

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between bind by copy and bind by reference?

1720


What is ment by record level identifier?

647


How can we override a file during runtime in rpg?

680


what is program status data structure?

1370


which program rpg or cl is efficent to update a transaction onto a database file and why ?

736






What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

2513


How can we know running job is batch or interactive?

647


how do I declare a minor?

707


How to handle duplicate error handling in RPG?

1672


How to call one program from another program in RPG? please help me with the code

1252


what is kids-rpg?

661


When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

496


what are the key words you must use when using a subfile?

684


can I touch the array during treatments?

750


How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?

1555