1.I Have a physical file , i want to read the data from the
each and every member of the File in the CL Program.How do
you achieve this.
2.How do you do the same in RPG?. do think is it possible to
read data from all the members in the RPG?

Answers were Sorted based on User's Feedback



1.I Have a physical file , i want to read the data from the each and every member of the File in t..

Answer / sivaprasad

in CL

by OVRDBF we can load the data from all members in file.

OVRDBF FILE(INPUT) TOFILE(PAYROLL) MBR(*all)

in RPG

by EXTMBR(*all) can load the data from all members in file

Is This Answer Correct ?    18 Yes 0 No

1.I Have a physical file , i want to read the data from the each and every member of the File in t..

Answer / gagan44

Using DSPFD we get all the memebers in an outfile .Then use the command OVRDBF to override each member in outfile

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More RPG400 Interview Questions

two types of read performed in dataqueue?????

4 Answers   CTS,


There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known. how can we do this?Solution should be performance oriented

3 Answers   Cap Gemini, IBM,


i want code and what are used key words are ...like wrkmbrpdm screen (q) i have a file with 3 fields empno,empname,empaddr... here you give the empno it displays from that number to remaining empno's how? sub file screen: employee details pos to:empno then enter empno empname empaddr so file have 100 records from 1 to 100 so the above pos you give the 55 empno...it displays the from 55 to remaining... ...... please share this answel

2 Answers   IBM,


how can an indexed file be used as arrival sequence in RPG?

3 Answers   IBM,


where we give the MSGSFL in rpg400?

4 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  


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

0 Answers   iGate,


what is the equivalent keyword for CHAIN opcode ??

7 Answers   TCS,


Hi guys. Im in AS/400(RPGLE,CLP) from last 1 year.Now i wan to upgrade my Knowledge in AS/400. Suggest me some new fields & courses which falls under AS/400. Waiting for your quick Response.

1 Answers   Voltech,


The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers  


what is plat file?

6 Answers   Indian Infotech,


use of PUTOVR,OVRDTA,KEEP keywords?

2 Answers   HCL,


Categories