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


OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes)
In which scenario is share(*yes) used?
could any one explain with an example?

Answers were Sorted based on User's Feedback



OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could a..

Answer / shruti tayal

Suppose you define override on a physical file with
SHARE(*YES) in a CL program, and you call HLL programs from
CL program, by defining SHARE(*yes) all programs who use the
overridden file, will use the same data path, on the
contrary if we dont specify share(*yes), each program will
create its own data path. This is very useful when we use
OPNQRYF, if we dont specify SHARE(*YES) for the file, the
data path created by OPNQRYF will not be of any effect in a
HLL program, as HLL program will create its own data path in
absence of SHARE(*YES).

Is This Answer Correct ?    30 Yes 0 No

OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could a..

Answer / suju

when we use share(*yes) ODP(open data path) will be shared.
other wise each time system wl create new ODP.its an
overhead.

Is This Answer Correct ?    28 Yes 1 No

OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could a..

Answer / shobhit

Share(*yes) means Sharing the access path of a file….
For example
Suppose Physical file have 5 members and you want to access
the records of 3rd member in your program. So OVRDBF
command will be like this.

OVRDBF (File Name) TOFILENAME (File Name) MEMBER (3rd)
SHARE (*YES)
CALL RPG

The RPG program now point to 3rd member of the file and if
you dont use SHARE(*YES) the program will point to 1st
member of the file.

Is This Answer Correct ?    11 Yes 31 No

Post New Answer

More IBM AS400 AllOther Interview Questions

Please give me the code for A=A+1 in cl program?

2 Answers  


What is the Function of PDM?

1 Answers  


does we use case stmt in cl

1 Answers  


what is pointer error in rpg IV?

4 Answers   CTS,


How many PARM statement can we use in a CL program?

6 Answers  


define the purpose of the %sst function?

1 Answers   IBM,


what is a join logical file?

0 Answers   IBM,


What is the difference between Interactive & Batch Job?

1 Answers  


what is a logical file?

1 Answers   IBM,


what is library?

1 Answers   IBM,


Can anybody know difference between SNDUSRMSG AND SNDPGMMSG IN CL PROGRAMMING? IF DON'T KNOW MAIL ME @ gkarthik.as400@gmail.com

3 Answers  


what are the different opcodes available in rpg for database access ?

1 Answers   IBM,


Categories