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
- 16201 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 |
why we use binding directory and service pgm
a multiple format logical file is also known as?
What is GDA?
what is the use of jdftval in join logical file?
What is a job log?
how to declare a constant variable in the freeformat?
how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE
What is a Library in AS/400?
what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.
If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...
What is the purpose of OPNQRYF (Open Query File)?
How to change file attributes such as size, file wait time, record wait time etc., permanently?
RPG400 
