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
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 |
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 |
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 |
Please give me the code for A=A+1 in cl program?
What is the Function of PDM?
does we use case stmt in cl
what is pointer error in rpg IV?
How many PARM statement can we use in a CL program?
define the purpose of the %sst function?
what is a join logical file?
What is the difference between Interactive & Batch Job?
what is a logical file?
what is library?
Can anybody know difference between SNDUSRMSG AND SNDPGMMSG IN CL PROGRAMMING? IF DON'T KNOW MAIL ME @ gkarthik.as400@gmail.com
what are the different opcodes available in rpg for database access ?