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 do you do indexing in a physical file?

2 Answers  


Why we cannot call a service program? If I add a PEP can i call the service program?

1 Answers   DELL,


Anybody know the difference of primary file and full procedural file

4 Answers  


How can we know running job is batch or interactive?

0 Answers  


which program rpg or cl is efficent to update a transaction onto a database file and why ?

0 Answers   IBM,






suppose i i am changing / updating record of subfile and i want to change the record in reverse order . means i want to change the bottom record first and so on through readc . how i do it please any one explain .

4 Answers   CSC,


what is EXCEPT command in rpg and use

1 Answers   Active Brains,


What is the Record Address file. How can we use it in RPG program?

4 Answers  


1.How can you search an entire source file for a particular field name? 2.How can you find the differences between two versions of the source for the same program? 3.What is a hidden field as it relates to a sub file? 4.How do you display a sub file that has no records in the sub file?

8 Answers   HCL,


purpose of pannel group??/

2 Answers   CTS,


i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in pf i have a name called demo appeared around 52 times hw will we read this particular records in rpg/400?.

11 Answers   IBM,


Can any body give the code for this quesition? Using the following details write C-Spec code to set Name to"AMMU LABS SYSTEM" D NAME1 S 10 INZ('AMMU') D NAME2 S 10 INZ('LABS') D NAME3 S 10 INZ('SYSTEM') D NAME S 20

5 Answers  


Categories