SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-45
S
Statistics (continued)
enabling display of S-41
file F-22
for partition U-10
from PREPARE P-25
retrieving from catalog tables U-10
selecting current compiler with U-9
updating U-7
using for better access plan S-78
STATISTICS display, FILEINFO
command F-22
STATISTICS option
FILEINFO command F-10
SET SESSION command S-41
STATISTICSTIME, in BASETABS table B-1
Status, checking with SQLCA I-4
STOP AT option, CONTROL TABLE
directive C-83
Stopping a SELECT command C-2
Storage Management Foundation
(SMF) S-78
Stored commands
deleting R-16
displaying S-52
stored Commands
displaying S-52
stored commands
deleting R-16
displaying S-52
String functions S-80
String literals
and quotation marks S-81
description of S-80
Structured files F-8
Style options
displaying S-54
resetting R-19
saving in file S-2
setting S-45
UNDERLINE_CHAR U-1
STYLE option, SAVE command S-3
Subqueries
comparing expression to results Q-6
correlated S-83
description of S-82
in EXISTS predicate E-12
nested S-83
nesting limit of L-13
SUBSORT DEFINEs D-33
Subsorts for loading indexes C-145
SUBSORTS, parameter for FastSort Z-4
Substituting values with parameters P-11
SUBSTRING function S-84
SUBSYSTEMNAME
in CATALOGS table C-11
in VERSIONS table V-9
SUBTOTAL command
and BREAK ON command S-86
description of S-86
SUBTOTAL_LABEL layout option R-10,
S-88
Subvolumes
default V-11
names of C-8
SUM function S-89
Summary reports D-50
Super ID
description of S-90
used by audit fix-up process W-6
SUPER.SUPER user S-13
Suppressing headings in reports H-1
Suppressing row count display R-23
SWAP, parameter for FastSort Z-4
SYNCDEPTH option, CONTROL TABLE
directive C-84
SYSKEY
and user-defined keys U-16
column C-28, S-90
SYSKEY clause, INSERT statement I-14
SYSKEYs S-90
SYSNUMBER, in TRANSIDS table T-11