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



Suppose you have 3 members in a database file. How to read records from all the members With..

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

Suppose you have 3 members in a database file. How to read records from all the members With..

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

Suppose you have 3 members in a database file. How to read records from all the members With..

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




Suppose you have 3 members in a database file. How to read records from all the members With..

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

Suppose you have 3 members in a database file. How to read records from all the members With..

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

Suppose you have 3 members in a database file. How to read records from all the members With..

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

Post New Answer



More IBM AS400 AllOther Interview Questions

How many PARM statement can we use in a CL program?

6 Answers  


how may a cgi control duplicate inputs?

0 Answers   IBM,


define the purpose of the iter operation?

1 Answers   IBM,


pf named karthik 3members jan feb mar cmd must executed create mbr ar ap

0 Answers  


whare we can use IN AND OUT AND UNLCK opcodes?please can any body tell me in real time senario with example

2 Answers  






define a output queue?

1 Answers   IBM,


What is SFLSIZ ?

1 Answers  


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

0 Answers   Virtusa,


what does check opcode do ?

1 Answers   IBM,


difference between view and index ?

0 Answers   IBM,


What is SAA?

1 Answers  


What is Job, What are the attributes of a Job?

1 Answers  






Categories