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 you determine the number of characters in a variable?
HI,1: What is the function of 'SETON LR' AND '*INLR=*ON ? 2:Can we used "seton lr" OR "*INLR = *ON" in between the program code ? 3:if yes then according to there function the code which is written acter seton lr/ *inlr should not be execute . Can any one tell me why those code get executed ?
how do you use commitment control in rpg?
what built in function can be used with SETLL.If you want to check whether the search argument is successful or not? Please give me answer with example?
1)how to do date validation in rpg? 2)how to delete dUPLICATE RECORDS?
how to change the length of the field in a physicalfile?
can you debug ile rpg program using isdb?
is this a rpg channel?
WHAT IS MONMSG IDENTIFIER FOR STRTCPFTP command IN cl (as/400)?
How can you delete records form a file in rpg without using "Delete" OPCODE?
without logical file we cannot access the data in physical file.but we specify physical file in the program(ie:- Ffile IF E k disk).how can it be accessed?
what is edit word and edit code