How can we search particular records from the database file in RPG. For exa

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?

Question Posted / nagendra

4 Answers
11255 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we search particular records from the database file in RPG. For example, there are 10..

Answer / prabhakar

This can be done using SETLL and READE

Is This Answer Correct ?

13 Yes

3 No

How can we search particular records from the database file in RPG. For example, there are 10..

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

How can we search particular records from the database file in RPG. For example, there are 10..

Answer / maha

by using runqry *n file name rcdformat(*slt)

Is This Answer Correct ?

0 Yes

0 No

How can we search particular records from the database file in RPG. For example, there are 10..

Answer / arvind

no IF so go wid DOU loop

f pfxx if e k disk
c dou *in90=*on
c name reade r1 90
........
......
enddo
c eval *inlr=*on

cud help i try it working many time

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More RPG400 Interview Questions

Can any one plz explain the concept of INFSR, *PSSR, INFDS AND PSDS, I' confusing about PSDS and *PSSR, Wat is the difference btw them, wat PSDS will do????

1 Answers

Suppose I have 3 jobs a b and c. I want to submit b after successful completion of a and want to submit c after successful completion of b. Without using job scheduler or job queue, how can I do that through cl program?

1 Answers

wat is meant by hidden field , why it is used?

4 Answers Four soft,

Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?

3 Answers

Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg

0 Answers

How can we receive values from a called procedure in CL?

1 Answers IBM, NTT Data,

How can we call CL program to RPG? How many number of parameter we can pass

2 Answers TCS,

How to select highest score of each subject or how to select highest income of every month?

0 Answers

i)What is the command to lock a file in a program ii)2. Can you get a level check error in a CL program

6 Answers

We have a Physical file, after reading 5 records,it has to read LF of that same Physical file,Will it start reading from Ist record or will start reading from 5th record?

5 Answers Hexaware,

If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?

1 Answers

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

0 Answers Wipro,

For more RPG400 Interview Questions Click Here