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

wat is the difference between dataarea and data queue?

5 Answers   Airtel, Four soft, Shahi Exports,


what is overlay? how can we pass parameters in cl or rpg programing? how can we get data area value in cl or rpg programming?

2 Answers   IBM, Patni,


Can anybody tell me that why we use option(*nodebugio)in H- Spec?

3 Answers  


1.If *HIVAL SETGT is used what opcode is used to read a record? A:READ B:READPE C:CHAIN D:READP 2.How to pass numeric parameter to the rpg pgm from the command line? 3.What keyword is used on the rpg 4 definition specification to rename a subfile in an externally definition data structure? A:RENAME B;LIKE C:EXTNAME D:EXTFLD

4 Answers   Manhattan,


can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com

0 Answers  


How can we change element of compile time array?Can we do so

1 Answers   TCS,


wat is meant by hidden field , why it is used?

4 Answers   Four soft,


I have a PF(ABC)with no key fields. PF(ABC)have 2 fields (cusno and cusname). Please let me know how can i read the cusno = 1150 directly from PF in CL and RPG program(Without creating the LF and without reading the complete file and then compare 1150)

3 Answers   Opus,


Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?

2 Answers   TCS,


Difference between RESET and CLEAR

1 Answers   TCS,


1.How you will find the program is batch or online in cl pgm? 2.How you will end the batch pgm when the job runs? write an logic? 3.In wich command the option *drop is used?

2 Answers   TCS,


Hi, I am getting the error in RPG (All Record Formats for externally-described file ABCD ignored or dropped due to error; file ignored.) Please suggest any

2 Answers   Satyam,


Categories