Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 11097 Views
- CTS, I also Faced
- E-Mail Answers
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 |
can i use unique key in LF
3 members in databasefile .how to read records from all the members??
1.I Have a physical file , i want to read the data from the each and every member of the File in the CL Program.How do you achieve this. 2.How do you do the same in RPG?. do think is it possible to read data from all the members in the RPG?
How do I read records from Subfile? what is the purpose of READC explain with example?
Can we found a record existance in a file w/o reading the file?
6 Answers Traitsys Technologies,
What is file identifier where we can use?
How Chain operation copies the record's data to the input buffer for the program?
How can you delete records form a file in rpg without using "Delete" OPCODE?
1)how to do date validation in rpg? 2)how to delete dUPLICATE RECORDS?
can we use cl programming to update or delete physical files
1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?
I have some doubts on subfile----------- -----I wrote a prog on subfile to display the records. Every thing is clear but i defined a field called "opt" as input field in subfile record format from that input field i wish to enter into new screen called "EDIT" which i created it as a separate RCD in display file. i gave opt as 2 for edit just like in WRKMBRPDM screen please telll me the code and how can i code for it in RPG.
RPG400 
