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

What is the difference between RPG/400 and RPG4

1 Answers   HCL,


how can we know running job is batch or intractive ? i need all the possibilites.........plz help me

3 Answers   HSBC, IBM,


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

1 Answers  


program to find the number of objects used in a given program through a display.

2 Answers   IBM,


I need to generate outfile for object of all the user lib. in the sysmte using cmd DSPOBJD. But this cmd is correcpted in my server,Any body tell me is there any alternative...?

2 Answers  






please guys help me,I need to write a program that shows more than one way to display a subfile. Both views are of the same file but sorted differently and show different fields of the same file when the user presses a function key. send me code

4 Answers   Virtusa,


How we will read call stack?

4 Answers  


Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

0 Answers  


can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.

0 Answers  


When PGMA calls PGMB for the first time PGMB executes the *INZSR. PGMB uses the RETRN operation to return to PGMA. When PGMA call PGMB the second time is the *INZSR executed?

5 Answers   Mphasis,


Q:Hi all,i want accurate answer with code using in built functions.please sent me code as soon as posible. I have program nmed PGM1 which '' RETRIEVE Current production date''should correctly default the production date for the user who is issuing raw materials to the manufacturing.The production date can be different from the celendra date. However, the program does not make the correct adjustment for all manufacturing plants. there is a parameter which determines the production start time e.g. 07:00 if the system time precedes this,the program subtracts one from the celendra day.This work fine when the celendar day starts after production day as it does in England,the system should be adding one to the celendar day during the overlap. unfortunately the program was desined to assumed the celendar day always starts before the production day. Change required in the program: Change the PROGRAM PGM1 to use the new parrameter to decide whether to add or subtract 1 from the celendar day when determining the production date.

0 Answers   TCS,


What would be the result on writing a data record to a PF file using the "WRITE" opcode after the SETON *ON *INLR statment?

10 Answers  


Categories