NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-27
Using DEFINEs
•
=_SORT_DEFAULTS
•
=_SQL_CAT_HEAP_LIMIT
•
=_SQL_CMP_EQ_LIMIT
•
=_SQL_CMP_EVENT
•
=_SQL_CMP_EVENT_NO0
•
=_SQL_CMP_NO_KS_MJOIN
•
=_SQL_cmp_node
•
=_SQL_EXE_USE_SQAPVOL
•
=_SQL_MSG_node
•
=_SQL_RECGEN_node
•
=_SQL_TM_node_vol
Each of the preceding DEFINES has an entry describing it. If using SQLCI HELP to
access the text, be sure to include the “=_” characters in the DEFINE name.
Use DEFINEs carefully. DEFINEs that identify the wrong objects can cause unexpected
results. Check that the DEFINEs in effect identify the objects that you want to use.
Create Guardian command files or OSS shell scripts for sets of frequently used
DEFINEs.
Using DEFINEs
DEFMODE is an attribute of a process that controls whether you can create DEFINEs
from the process and whether DEFINEs are propagated when the process starts another
process. The process can be a TACL process, an OSS shell process, an SQLCI process,
or a process of your own creation. The DEFMODE attribute can be set to ON or OFF.
If DEFMODE is ON, you can create, modify, delete, propagate, and display information
about DEFINEs. For example, if you start an SQLCI process from a TACL process with
DEFMODE ON, DEFINEs set in the TACL process are propagated to the SQLCI
process. Similarly, you can set DEFINEs in an OSS shell process and the DEFINEs are
propagated to a process you start from an OSS program with embedded SQL statements.
DEFMODE ON is the default. Note that for OSS processes, DEFMODE ON becomes
the default after the first add_define command is issued.
If DEFMODE is OFF, DEFINEs are ignored and you cannot create new DEFINEs. You
can still modify, delete, and display information about existing DEFINEs, but such
DEFINEs have no effect because they are not propagated to other programs. (The
=_DEFAULTS system DEFINE is a special DEFINE that is an exception to this rule and
that is always propagated. See =_DEFAULTS DEFINE
on page Z-2 for more
information.)