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

how do u track msg in cl pgm???

1 Answers   CTS,


1) How to retrieve RRN through RPG ? 2) How to pass parameter by value ? 3) How to trap the error through the RPG/400

10 Answers   IBM, Tech Mahindra,


Can we trigger an rpg program which has user interaction with display file when updating a file using the command ADDPFTRG?

2 Answers  


In a particular program one file is used where override command is applied to a file, now this program calls another program where we want to use the same file but without override.How it can be done?

6 Answers   Hexaware,


How can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.

4 Answers   IBM,






What will be your approach in going either for OPNQRYF or Logical files. Which one to go for?

2 Answers  


what is the rpg system?

0 Answers   IBM,


What are the types of identifiers?

0 Answers  


1.find most occurrences of a character. for exm: input:aaabbbbdddddyyy output: d 5 times how can i get that?

13 Answers   HCL,


how can I tell when to replace the array?

0 Answers   IBM,


How do you do indexing in a physical file?

2 Answers  


what is edit word and edit code

0 Answers   Cap Gemini,


Categories