NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-46
S
setting S-46
UNDERLINE_CHAR U-1
STYLE option, SAVE command S-3
Subqueries
comparing expression to results Q-6
correlated S-82
description of S-81
in EXISTS predicate E-12
nested S-82
nesting limit of L-11
SUBSORT DEFINEs D-31
Subsorts for loading indexes C-136
SUBSORTS, parameter for FastSort Z-4
Substituting values with parameters P-12
SUBSTRING function S-83
SUBSYSTEMNAME
in CATALOGS table C-9
in VERSIONS table V-8
SUBTOTAL command
and BREAK ON command S-85
description of S-85
SUBTOTAL_LABEL layout option R-12,
S-87
Subvolumes
current default Z-2
default V-10
names of C-6
SUM function S-88
Summary reports D-47
Super ID
description of S-89
used by audit fix-up process W-6
SUPER.SUPER user S-13
Suppressing headings in reports H-1
Suppressing row count display R-25
SWAP, parameter for FastSort Z-4
SYNCDEPTH option, CONTROL TABLE
directive C-79
SYSKEY
and user-defined keys U-17
column C-26, S-90
SYSKEY clause, INSERT statement I-14
SYSKEYs S-90
and entry-sequenced tables S-90
and key-sequenced table S-90
and relative table S-90
SYSNUMBER, in TRANSIDS table T-11
System catalog
creating C-142
description of S-91
dropping D-64
upgrading U-13
versions V-7
SYSTEM command S-91
System default multibyte character
set M-25
SYSTEM default value D-25
System defines
summary S-92
=_AUDSERV_XSWAP_node Z-1
=_DEFAULTS Z-2
=_SORT_DEFAULTS Z-3
=_SQL_AUD_node Z-13
=_SQL_CAT_HEAP_LIMIT Z-5
=_SQL_CAT_node Z-13
=_SQL_CI2_node Z-13
=_SQL_CMP_CPUS_node Z-6
=_SQL_CMP_DOUBLE_SBB_OFF Z-
8
=_SQL_CMP_DOUBLE_SBB_ON Z-8
=_SQL_CMP_EQ_LIMIT Z-9
=_SQL_CMP_EVENT Z-10
=_SQL_CMP_EVENT_NO0 Z-11
=_SQL_CMP_node Z-13
=_SQL_cmp_node Z-13
=_SQL_CMP_NO_KS_MJOIN Z-12
=_SQL_EXE_DOUBLE_SHUTOFF Z-
14
=_SQL_EXE_ESPS_CK_CMON Z-14