Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.

2 Answers   iGate,


Can we journel logical file and access path? Can we use commitment control for non-join L.F?

4 Answers  


what is flat file?

1 Answers   IBM,


How do you call procedures in ILE?

3 Answers  


Whether a module can consists of many procedures or it can consist of subprocedures having a main procedure?If it is possible that it can contain many individual procedures than can we have different name for complete module and how do we call this module in main modul?

3 Answers   Steria,


What will happen if we r using seton lr after return or vice versa.

5 Answers  


Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE('TCS AS/400') DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2 after excuted of CHGVAR command.

2 Answers  


in a cl pgm records are copied to a file in qtemp a pgm is called to delete records from the file in qtemp no of records in file in library qtemp is checked wat shud be the count of records let say it was 10 initially endpgm

2 Answers  


1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

6 Answers   Virtusa,


how do u track msg in cl pgm???

1 Answers   CTS,


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,


1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?

4 Answers   IBM,


Categories