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

how can I predict the performance of my cgis?

0 Answers   IBM,


Difference Between Ca & Cf?

0 Answers   IBM,


What is difference between rename and prefix?

0 Answers  


Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?

5 Answers   HCL,


In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project.

0 Answers   Adverb Solutions, CSC,






What is the function of RJE Conversion Utility?

1 Answers  


what opcode will be used to test the zone of a character field?

1 Answers   IBM,


what are the different types of data areas?

1 Answers   IBM,


What is a library list ?

1 Answers  


What is SDA used for?

7 Answers  


what is data structure?how many types of data structers?

4 Answers  


how to toggle between single line and multi - line display of a particular record in a subfile?

1 Answers   IBM,


Categories