Suppose you have 3 members in a database file. How to read
records from all the members without using CL (OVRDBF) i.e.
Entire process should be handled exclusively in a 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 without usi..

Answer / kcsyam

use EXTMBR('*ALL') keyword on F specification

Is This Answer Correct ?    16 Yes 1 No

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

Answer / milan kumar banerjee

One way could be using CPYF copy all the members into a
single member of a file and then process the new file in
the RPG.

Is This Answer Correct ?    3 Yes 0 No

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

Answer / phalgun

Use OVRDBF command in RPG using QCMDEXC

Is This Answer Correct ?    2 Yes 0 No

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

Answer / murali

It is not possible to read all the members through OVRDBF, you need to override the file in the CL and use use EXTMBR('*ALL') keyword on F specification in RPGLE

Is This Answer Correct ?    2 Yes 0 No

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

Answer / as400 gem

The above answer is perfectly right!

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 without usi..

Answer / prasanh

Hello, EXTMBR key word can be used in RPGLE program, but the
question is how to use it in RPG?

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 without usi..

Answer / ravikumar

2nd and 3rd answers are correct...

Yes, EXTMBR(*ALL) is used in RPGLE program...

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More RPG400 Interview Questions

Anybody can explain the difference between SFLCLR & SFLINZ?

7 Answers  


HOW DO YOU DISPLAY A DISPLAYFILE AT OTHER WORKSTATION? CAN WE MOVE A PHYSICAL FILE? WITHOUT MOVING A FILE?

2 Answers  


what built in function can be used with SETLL.If you want to check whether the search argument is successful or not? Please give me answer with example?

3 Answers  


this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002

1 Answers  


How to create a key field for a logical file inside RPG?

4 Answers   HSBC,






How to read a record from file where there is multiple record occurrence is available?

1 Answers  


what is the difference between the procedure and module in ILERPG?

4 Answers  


difference between CHAIN and READE?

8 Answers   HCL,


what are the key words you must use when using a subfile?

0 Answers   IBM,


Given the following code, what is the value of RESULT? DName+++++++++++ETDsFrom+++To/L+++IDc.Keywords+++++++++++++ D RESULT S 5 0 C EVAL RESULT = (2 + 3 * 2) ** 2 / 2

2 Answers  


what is commitment control?explain about it?

1 Answers   HSBC,


Can AnyOne tell me how to read join logical file in rpg from starting to end?

2 Answers  


Categories