How To Search Particular Records From The Database File In RPG?Suppose, 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?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home IBM AS400

⟩ How to search particular records from the database file in RPG?Suppose, 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?

This can be done using the Key Field.

KEY1(NAME FIELD) SETLL FILENAME

KEY1(NAME FILED) READE FILENAME

Is this answer helpful?
0 Yes | 0 No

133 views

More Questions for you:

How to receive data passed through JCL parm parameter in a Natural program? How Data definition is defined in the program?

Explain difference between read(1) and read work file once?

Explain difference between read work file 1 and read work file once? Why we are using work file once?

Explain ADABAS basic concepts. Like inverted list, address converter ,data storage?

What is a hyperdescriptor? How does it work?

What is the quality process in development?

A field declared as P8 needs to be redefined as Alphanumeric. What would be its new size?

How to create 1 DDM that fetches 3 ADABAS files simultaneously?

Is it possible to declare a GDA for an external subroutine?

If the number of parameter is more than the expected then NAT0919 error is displayed. How many parameter are allowed in a CALL and CALLNAT statement?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home IBM AS400

⟩ How to search particular records from the database file in RPG?Suppose, 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?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home IBM AS400

⟩ How to search particular records from the database file in RPG?Suppose, 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?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: