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

Answers were Sorted based on User's Feedback



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

Answer / samul

OVRDBF FILE(TEST)
TOFILE(*LIBL/TEST)
MBR(*ALL)

before calling pgm,execute above cmd.

cheers...

Is This Answer Correct ?    9 Yes 3 No

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

Answer / reena

there are 2 ways.

1. using OVRDBF
2. By creating and LF.

Is This Answer Correct ?    3 Yes 0 No

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

Answer / prabakaran

Using EXTMBR

Is This Answer Correct ?    3 Yes 1 No

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

Answer / ravi kumar

1. Through RPG, using EXTMBR(*All)
2. Through CL, OVRDBF FILE(TEST) TOFILE(*LIBL/TEST)MBR(*ALL)

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More RPG400 Interview Questions

1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?

1 Answers   CSC,


What you have to do in the display file when you are using message subfile?

1 Answers  


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

5 Answers   IBM,


is this a rpg channel?

0 Answers   IBM,


we hav job which is running as batch. it takes atleast 06hours to complete tht job. bu i wana do tht job with in 3hours.........? so plz post ur answers

8 Answers   Cap Gemini, IBM,






I am reading a file in CL program. and MONMSG CPF0864 has arrived means EOF has arrived. Now i want to read this file again. How i can do this?

5 Answers   CitiGroup, Symphony,


What hapens when we use CPYF command to copy a LF? On which PF will it be dependent???

7 Answers   HSBC, Systime,


Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?

1 Answers   Infogain,


How can we search particular records from the database file in RPG. For example, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular 'NAME' field. How can we do the above using SEARCH criteria other than using the IF cond?

4 Answers   CTS,


during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.

0 Answers   IBM,


1.The questions have given an array declaration and move operation then this statement is correct or not?

3 Answers   TCS,


Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?

2 Answers  


Categories