On 14/03/2008, at 12:23 PM, Crispin wrote:
On page 10 of the document in the following link, Dan Cruikshank
says it
wasn't on the S/38, and you had to use REFACCPTH.
http://www-03.ibm.com/servers/eserver/iseries/db2/pdf/
Performance_DDS_SQL.pdf
He says:
"In order for the HLL applications to use the 64K access path we need
to take advantage of the
built in access path sharing support of OS/400 (i5/OS). This support
is not new. On the
System/38 you needed to specify the REFACCPTH file level keyword
within your DDS source
for the keyed logical file you were creating. Those of us who were
aware of this keyword used it
to minimize access path maintenance."
He's wrong on two counts:
1) REFACCPTH was not available on CPF. It is new with OS/400 (and
it's not listed in my CPF 8.0 Programming Reference Summary)
2) Implicit access path sharing was available on CPF (at least on
Rel. 8.0) so it was not necessary to specify sharing
ACCPTH is listed in my S/38 Programming Reference Summary:
"Explicitly specifies that the keyed-sequence access path of a
previously created logical or physical file is to be shared by the
file you are creating."
Keyword is valid for LF only at the File level. Not valid for Join LF.
Compare with REFACCPTH from current DDS reference.
"You can use this file-level keyword to specify that the access path
information for this logical file is to be copied from another
physical or logical file."
Note the use of "copied" in REFACCPTH? This just copies the
definition. Sharing still happens automatically.
Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists
http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------
midrange.com
