3 members in a databasefile .how to read records from all the members?????????

3 members in a databasefile .how to read records from all
the members?????????

Question Posted / ddd

4 Answers
9446 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

3 members in a databasefile .how to read records from all the members?????????..

Answer / samul

OVRDBF FILE(TEST)
TOFILE(*LIBL/TEST)
MBR(*ALL)

before calling pgm,execute above cmd.

cheers...

Is This Answer Correct ?

9 Yes

3 No

3 members in a databasefile .how to read records from all the members?????????..

Answer / reena

there are 2 ways.

1. using OVRDBF
2. By creating and LF.

Is This Answer Correct ?

3 Yes

0 No

3 members in a databasefile .how to read records from all the members?????????..

Answer / prabakaran

Using EXTMBR

Is This Answer Correct ?

3 Yes

1 No

3 members in a databasefile .how to read records from all the members?????????..

Answer / ravi kumar

1. Through RPG, using EXTMBR(*All)
2. Through CL, OVRDBF FILE(TEST) TOFILE(*LIBL/TEST)MBR(*ALL)

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More RPG400 Interview Questions

why we do STRSRVJOB in batch debugging in as400

1 Answers

Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?

0 Answers

How to call one program from another program in RPG? please help me with the code

0 Answers HCL,

ESCAPE message sent by child program can be handled by parent program using which keyword?

2 Answers

Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?

3 Answers

How can we receive values from a called procedure in CL?

1 Answers IBM, NTT Data,

In RPG program one file using as a PRIMARY file while running program some of the records reading twice any body know why its happening

2 Answers

1.CA(command Atention key)& CF(command Function key) difference with example?Please can any body tell me in real time exp? 2.Can any body tell me some mandatery function keys using while creating any screen with use of SDA-FUNCTION kEYS?

5 Answers HCL,

what is an online rpg?

0 Answers IBM,

how we create binder member for updating service program and where we type this code on command line or in program ? strpgmexp pgmlvl(*current) export symbol (xyz0 endpgmexp. plz explain me this step by step .

2 Answers

How to find d key field of a pf that doesn’t have source physical file?

2 Answers

1. Which Built-In-Function will you use to achieve the following functionality? CLONO1NO2NO3 Factorl÷÷+OpcdeFactor2++÷ResultLenDHHiLoEq C QTY IFLT *ZERO C QTY MULT -1 QTY C ENDIF a) %ABS b) %TRIM c) %TRIMS d) %UNS

3 Answers IBM,

For more RPG400 Interview Questions Click Here