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

As Packed veriable store 2 digits in 1 byte and ZONE variable store 1 digit in 1 byte... Please tell me when we have to use Packed and Zone variable...?

1 Answers  


How Commitment and Roll back control is used in as400, explain with real time senario ???

2 Answers   Acolite, HSBC,


In single page subfile,if I select the mutiple options in 1 page and without pressing enter,I press rollup key (pagedown).In such case how I can handle it in rpg becasue in single page we have to handle it in pgm. It would be helpful if any one answer with coding

4 Answers   Infinite Computer Solutions,


A rpg or clp command to find if the file field is defined as a character or numeric field.

1 Answers   IBM,


i would like to know under what circumstance the object will get locked on AS400.

5 Answers   IBM,






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

0 Answers   HCL,


How I can reread the physical file in CL program once the end of file reached in same CL program.

20 Answers   IBM,


how many variables can we declare in cl pgm?

13 Answers  


suppose we have 10 members in physical file and i have to use 4 out of 10 so how can we read this in RPG

3 Answers   TCS,


Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ('PEN') D CHR2 S 10A INZ('MYGET') D CHR3 S 8A INZ('GOOD') D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4

4 Answers  


use of PUTOVR,OVRDTA,KEEP keywords?

2 Answers   HCL,


how to change the length of the field in a physicalfile?

12 Answers  


Categories