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?
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 |
What is Multi-format logical file?
Write a CL program which will run a batch job at 1 am every night
Define what the operation will do, the purpose of the result field and the purpose of *IN66? HI LO EQ C CALL 'CVTDAT' DTPRM 66
List the steps/commands necessary to accomplish the following: a. Copy data from the file ORDHDR into file ORDHIST b. The file ORDHIST may or may not exist c. If the file ORDHDR does exist, it may or may not contain data d. The file ORDHIST may or may not contain data, if the file does contain data the old data should be erased
Q.Suppose one job is running in a batch mode for a long time now i want to kill this batch job. how you achive this?
does we use case stmt in cl
what are the necessary keywords for the join logical file?
what are activation group and what are its types.?
. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?
what would be the effect on the field where reverse image, underline and highlight display attributes are active ?
Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out
What is Folder?