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
- 13472 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 |
WHAT IS MEANT BY SIGNATURE VAILOTION ERROR
how do I play {insert rpg system here}?
How do you do indexing in a physical file?
how to check on which PF , the LF is dependant ?
I want to add 10 days in current date. how it is possible in CL program...?
what is use of sflnxtchg and use of MDT(modify data tag).both r same r not and can we use these on dspf and subfile.
Some times While checking MSGW for object / member / record locks ,I have seen it's locked by itself ...? How it happen and what action we need to perform if job is updating / writing a record....?
what is program status data structure?
What is the purpose of PUTOVR keyword?
I am Submitting one job in batch that job calls three progams(PGMA, PGMB, PGMC). PGMB should be called after sucessfully completion of PGMA as like for PGMC also. So Can you please tell me how can we do that (without using data area)
HI, 1: WHAT IS THE FUNCTION OF %KDS?WITH PROGRAMMING CODES EXAMPLE 2: WHAT IS THE FUNCTION OF Z-ADD AND Z-SUB ? WITH PROGRAMMING CODES EXAMPLE
Errors in Sql query will be in which state?
RPG400 
