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?
Answers were Sorted based on User's Feedback
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 |
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 |
how can we can we the data decimal error?how can we open such file in support
can anyone say,what is the use of operation extended H/N/P?
How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)
What is the name of default out queue when user logs inn to syatem with valid profile?
what is the difference between SETON RT & RETURN?
how do I declare a minor?
Difference between creating a report using Printer file and WRKQRY(Query Report) ?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
can i use UPDDTA command in rpg program in which contains a file
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?
Can AnyOne tell me how to read join logical file in rpg from starting to end?
Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?