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

Answers were Sorted based on User's Feedback



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

Answer / guru

Reading all the members in a pf cannot be achieved in a
single override command and which is cumbersome too. So
rather using override, you can use EXTMBR('*ALL') in the
file specification in your rpgle program. So when you read a
file, it will automatically read all the members records
from your data base file. This is FYI

Regards
Guru

Is This Answer Correct ?    14 Yes 0 No

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

Answer / ramesh

fFile if e disk extmbr(*ALL)

Is This Answer Correct ?    9 Yes 0 No

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

Answer / swadesh

With the OVRDBF command give the member name as *all.

Is This Answer Correct ?    6 Yes 1 No

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

Answer / shishir

in cl as explained by swadesh sir ..........ovrbdf *all
ok

Is This Answer Correct ?    1 Yes 0 No

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

Answer / ravi shankar porwal

U can also read the records of all members using logical
file.create logical file based on given PF(have more than
one member) and read it using rpgle program.

Is This Answer Correct ?    2 Yes 2 No

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

Answer / sai reddy

Hi Guru,

How can we do the same thing in CL ?..i mean can you explain me how to read data from all members of a PF in CL

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More RPG400 Interview Questions

How to read alternative records in a pf by using rpg?

8 Answers   IBM,


What will happen if we r using seton lr after return or vice versa.

5 Answers  


Are all these RPG/400 Interviewed Questions being asked recently? are current?

1 Answers  


I have a Physical File name 'File1', which is present in two libraries named 'LIB1' & 'LIB2'. These 2 libraries are listed in the library list. Would like to access data from this file from these two libraries using RPG program. How to do this, any idea?

4 Answers  


what is the equivalent keyword for CHAIN opcode ??

7 Answers   TCS,






can anyone say,what is the use of operation extended H/N/P?

2 Answers  


what is batch debug in as400?

3 Answers  


Can someone tell me tell me what is meant by message wait...?

1 Answers  


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?

7 Answers  


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  


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

2 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  


Categories