Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose you have 3 members in a database file. How to read
records from all the members
Without using CL (OVRDBF) i.e. it should be handled
exclusively in an RPG program?
- 6 Answers
- 16801 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / reecha
Using EXTMBR(member name) in the keyword option in the F
specs. For eg.
F filename I F E EXTMBR(mbrname)
This will open the particular member of the file.
| Is This Answer Correct ? | 19 Yes | 1 No |
Answer / shruti tayal
In F-spec use EXTMBR keyword, specify *ALL in quotes as the
parameter value, this will cause all members of the file to
get processed.
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / sumit gupta
if you want to read a particular member/or all member
records in RPG program without OVRDBF in CL program. Then,
you can use EXTMBR keyword.
Declare a file in f specs and in keyword option write
1) EXTMBR(*ALL)
or
2) EXTMBR(MEMBER NAME)
Member Name must be in CAPS as if you dont put it in CAPS
then severity 30 error comes while compilation.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / vivek
USING MEMBER MAPPING IN LF THEN THIS LF USE IN RPG PROGRAM.
LET SEE,
PF@1 CONTAIN 3 MEMBER LIKE M1,M2,M3 AND FIELDS OF
NAME AND ID
LF@1
R R1 PFILE(PF@1)
K NAME
AFTER THAT LF USE IN RPG PROGRAM. TRy now.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / reena
Create a logical file which contains the 3 members. Later
user the LF in RPG Program
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / syam
Create diff. 3 RUNQRY with 3 members and save it. Run this
QRY inside the RPG Program thru using EXEC CL Cammand.
| Is This Answer Correct ? | 4 Yes | 11 No |
is it possible to create a physical file without dds?
What is the difference between Physical and Logical files ?
How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?
what is message subfile?
Can level check error occur if we do chgpf?
Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?
What is the purpose of PR and PI in calling program and called program? in Called program PR is compulsory?
Using %check we are checking monika in mona what is output? What is %SCAN?
define a output queue?
what is the purpose of ovrdta and ovrata keywords ?
all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?
how can you specify no duplicate key?
RPG400 
