Interested to Buy Any Domain ? << Click Here >> for more details...
I have a PF(ABC)with no key fields.
PF(ABC)have 2 fields (cusno and cusname).
Please let me know how can i read the cusno = 1150 directly
from PF in CL and RPG program(Without creating the LF and
without reading the complete file and then compare 1150)
- 3 Answers
- 13577 Views
- Opus, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijay
In CL PGM
do CPYF from file ABC to ABC qtemp with the selection
field (CUSTNO) = 1150 (value) so ABC in qtemp have only one
record with that cust no. then read this file in CL program.
In RPGLE...
you can used SQLRPGLE program and write a SQL select
statement on the on file ABC.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / mayank taneja
In CL program:
Ovrdbf and opnqryf
In RPG Program:
SQLRPGLE
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / manan---as400 so cute
CL
This can be done by two ways :- a)ovrdbf b) opnqry
RPG
This can be done by SETLL + READE or READ and the second
requirement by COMP
Cheers
| Is This Answer Correct ? | 6 Yes | 13 No |
When it is desirable to describe files Internally?
How can we receive values from a called procedure in CL?
what is overlay? how can we pass parameters in cl or rpg programing? how can we get data area value in cl or rpg programming?
You have a *USE authority on a Library and *All authority on a file in that Library.Can you change the data in that file?
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
Suppose I have 3 jobs a b and c. I want to submit b after successful completion of a and want to submit c after successful completion of b. Without using job scheduler or job queue, how can I do that through cl program?
1) How to define keyed file in CL pgm. 2) How can i read particular records in CL pgm from database file.
1.WHAT IS WRONG WITH THE CODE BELOW? C CUSTNO CHAIN CUSTMAST IF %ERROR can any body find the wrong please? 2.What builtin function will you use to achieve the following functionality? C QTY IFLT *ZERO C QTY MULT-1 QTY ENDIF
1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?
Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?
is this a rpg channel?
RPG400 
