NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-42
S
value comparisons C-55
values to insert I-14
values within a range B-3
Selecting from catalog tables S-31
Selecting rows
for DELETE operation D-38
for INSERT operation I-14
for UPDATE operation U-3
Selecting values from a list B-3
Select-in-progress prompt S-61
Select-list
dependencies on GROUP BY S-25
for distinct rows S-19
Self join S-31
SEQNUMBER
in COMMENTS table C-46
in CONSTRNT table C-65
in CPRLSRCE table C-126
Sequential access block size B-5
Sequential block buffering
See Virtual sequential block
buffering C-63
SEQUENTIAL BLOCKSPLIT option,
CONTROL TABLE directive C-77
Sequential blocksplits C-82, E-19
Sequential cache E-17
Sequential inserts C-78
SEQUENTIAL option, CONTROL TABLE
directive C-77
Serial writes
compared to parallel S-33
description of S-33
SERIALIZABLE, ISO Isolation Level S-70
SERIALWRITES file attribute S-32
SERIALWRITES, in FILES table F-29
ServerWare SMF S-76
ServerWare Storage Management
Foundation (SMF) S-76
Session
ending E-13
options
displaying S-54
resetting R-21
saving in file S-2
setting S-39
SESSION option, SAVE command S-3
SET DEFINE command S-33
SET DEFMODE command S-34
SET LAYOUT command S-35
Set operation
DELETE statement D-38
UPDATE statement U-3
SET PARAM command
COMPUTE_TIMESTAMP
function C-57
CURRENT_TIMESTAMP
function C-163, S-36
description of S-36
SET SESSION command
AUTOWORK option S-40
BREAK_KEY option S-40
description of S-39
DISPLAY_ERROR option S-40
ERROR_ABORT option S-41
ERROR_TEXT option S-41
LIST_COUNT option S-41
MANDATORY_REPORT option S-42
STATISTICS option S-42
WARNINGS option S-42
WRAP option S-42
SET STYLE command S-46
SETMODE 91,3 option C-78
SETSCALE function S-47
Shadow labels C-20
and CLEANUP command C-20
and FILEINFO command F-11
defined F-13
purging P-31
SHADOWSONLY option