AS/400 : DB2/400 file override
I have following scenario:-
- in CL, override on PF to share ODP
- Calling PGMx where above PF will be open using OPEN operation.
- In PGMx,once file is open,calling another pgm(PGMy) to read the same file ( PF ) for specific record using READ operation (without SETLL ).
Question : Record pointer in PGMy will be first record or next consequent record which read in PGMx
Software/Hardware used:
- in CL, override on PF to share ODP
- Calling PGMx where above PF will be open using OPEN operation.
- In PGMx,once file is open,calling another pgm(PGMy) to read the same file ( PF ) for specific record using READ operation (without SETLL ).
Question : Record pointer in PGMy will be first record or next consequent record which read in PGMx
Software/Hardware used:
ASKED:
December 18, 2009 9:51 AM
UPDATED:
December 19, 2009 7:10 AM
Answer Wiki:
With the Shared ODP there is only one "pointer" managed by the DBMS so if the PrgY reads a record and then ends and then PrgX reads a record it has the same effect as if prgX reads twice. Anything that moves the pointer moves it for the ODP .. read, setll, setgt, chain and if the file hits EOF it's at EOF for all programs.
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
What is specified for the OVRSCOPE() and OPNSCOPE() parameters? What activation groups are involved? What OPEN modes are used by the two programs — input, output or both?
Tom