Home > IT Answers > AS/400 > How to access all records in RPGILE
Ambrish 82
310 pts.
 How to access all records in RPGILE
AS/400 development, LOVAL SETLL, READE, RPG, RPG ILE, SETLL
hi all, suppose i have a report with input criteria 'machine code' and requirement it that if i input a perticular 'machine code' then it should COME only that , otherwise all records of all 'machine codes' should come , in clp i use %WLDCRD for that. but i need to do it in rpgile , is there any way to do it ????? please tell me.. thanks & regards Ambrish Srivastava

Software/Hardware used:
ASKED: December 10, 2008  5:21 AM
UPDATED: December 10, 2008  3:44 PM
RELATED QUESTIONS
Answer Wiki:
Hi, You could check to see if your selection field is filled, if it's filled use the value from the selection field to SETLL and READ or READE - otherwise use *LOVAL to SETLL and READ. Regards, Martin Gilbert.
Last Wiki Answer Submitted:  December 10, 2008  10:16 am  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

thats okey but i mean when when i don’t mentin any value there then (suppose ***** is there )then all record should be come..

Ambrish 82
 310 pts.
 

Martin’s answer asumes that the physical or logical is keyed on the field in question.
Upstream of this program passed as a parameter or in this program provided by a display screen you
get a value to report or ‘*****’ for all so your code woud setll and reade on the value unless it’s ***** then your code would Setll on *LOVAL and read until end of file.

Paste a brief bit of your code in here and we’ll help.

philpl1jb
 44,220 pts.