SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-14
=_SQL_CMP_NO_KS_MJOIN DEFINE
=_SQL_CMP_NO_KS_MJOIN DEFINE
=_SQL_CMP_NO_KS_MJOIN is a system DEFINE that inhibits SQL from using the
key-sequenced merge join operation.
name
must be a legal Guardian file name but has no purpose except to make the ADD
DEFINE command syntactically correct. If you do not set this DEFINE, a
key-sequenced merge join is considered.
Examples—=_SQL_CMP_NO_KS_MJOIN

This TACL command directs SQL to avoid using KSMJ:
32> ADD DEFINE =_SQL_CMP_NO_KS_MJOIN, CLASS MAP, FILE T1

To direct SQL to resume using KSMJ, delete the DEFINE as shown:
34> DELETE DEFINE =_SQL_CMP_NO_KS_MJOIN
=_SQL_cmp_node DEFINE
=_SQL_cmp_node is a set of system DEFINEs that identify files that hold components
of SQL/MP software. Only a user logged on with an ID from the group 255 can use
these DEFINEs to direct SQL to use alternate versions of its normal components.
cmp
is one of these components:
node
is the name of the node (without the usual leading “\”) that uses the specified
object file as a component.
ADD DEFINE =_SQL_CMP_NO_KS_MJOIN, CLASS MAP, FILE name
ADD DEFINE =_SQL_cmp_node, CLASS MAP, FILE name
cmp Normal $SYSTEM.SYSTEM file for component
AUD AUDSERV
CAT SQLCAT
CI2 SQLCI2
CMP SQLCOMP
UTL SQLUTIL