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
- 15182 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 |
which are the figurative constants used in rpg?
how can I predict the performance of my cgis?
how to define to define a hidden filed in dspf ?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
how many types of display are available on as/400 for user interaction?
the maximum number of subfiles that can be active for a single file is ____ .
how many maximum spaces could be given in o specs?
what is the maximum number of records you can specify in a display file?
what is arrival sequence?
how to run other job when one job is active?
what are the three line types in rlu ?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
RPG400 
