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 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

HI,1: What is the function of 'SETON LR' AND '*INLR=*ON ? 2:Can we used "seton lr" OR "*INLR = *ON" in between the program code ? 3:if yes then according to there function the code which is written acter seton lr/ *inlr should not be execute . Can any one tell me why those code get executed ?

2 Answers  


What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

0 Answers   Wipro,


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,


we are sending data of physical file to screen design and it is showing no record why?

1 Answers   NTT Data,


How to print output from openquery in as400 ?

1 Answers   Four soft,


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,


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,


How to index LF by relative record no (RRN)

1 Answers  


HI, 1: WHAT IS THE FUNCTION OF %KDS?WITH PROGRAMMING CODES EXAMPLE 2: WHAT IS THE FUNCTION OF Z-ADD AND Z-SUB ? WITH PROGRAMMING CODES EXAMPLE

1 Answers   IBM,


how do I preserve and clean the array?

0 Answers   IBM,


If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?

1 Answers  


1.Are there any errors in the following statement?If so then list them.DTAARA is a data area having a field EMP # and EMPNO is a field in the file EMPPF.Which has one record. READ EMPPF IF %FOUND(EMPPF) IN DTAARA EVAL EMP#=EMPNO OUT DTAARA ENDIF

5 Answers  


Categories