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 / 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 View All Answers
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
how can you display specific subfile page on the screen in unequal subfile?
what is program status data structure?
How would display prime numbers using CL program?
How to handle duplicate error handling in RPG?
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?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
what is the necessary keyword needed to scroll subfile records?
what do you mean by an input subfile, what are the keywords required?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
How to declare the pull button in AS/400..
what are the key words you must use when using a subfile?