Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

during input operation which indicator position is seton if there is a record lock?

1 Answers   IBM,


what does exfmt does?

1 Answers   IBM,


where exactly we can use OPNQRYF ?

3 Answers   TCS,


what is code for reading member in rpgle when wehave like extmbr(*all) so we have 3 members in *all then i want to read first record in 2member

2 Answers   HCL,


How can we sort an array?

1 Answers  


http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?

0 Answers   IBM,


it is possible declare variable values as variable using cl ? any cl command is there to declare values as variable

2 Answers  


how to change job priority when it is running in sub system ?

11 Answers   IBM,


i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.

0 Answers  


is there any way I can ease my rpg controls on numeric input fields? How about an input date field?

0 Answers   IBM,


what is term cua , saa?

1 Answers   IBM,


what does check opcode do ?

1 Answers   IBM,


Categories