SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-41
S
SEGMENT, parameter for FastSort Z-4
SELECT command, directing output of O-8
SELECT DISTINCT clause, and CREATE
VIEW statement S-68
SELECT statement
and scale S-47
BROWSE access S-21
cancelling, in SQLCI C-2
description of S-18
DISTINCT clause D-57, S-19
dynamic SQL S-24
FOR UPDATE OF clause S-24
FROM clause S-20
GROUP BY clause S-22
HAVING clause S-21
INTO clause S-19
lock mode option S-21
lock realease summary L-48
lock release summary L-48
ORDER BY clause S-23
restrictions for view definitions C-167
suppressing row count display R-23
table privileges S-68
UNION operator S-23
Selecting data
cursor declaration D-23
, D-24
distinct rows S-19
matching values L-2
search conditions S-5
value comparisons C-60
values from a list B-4
values to insert I-14
values within a range B-4
Selecting from catalog tables S-30
Selecting rows
for DELETE operation D-39
for INSERT operation I-14
for UPDATE operation U-3
Select-in-progress prompt S-60
Select-list
dependencies on GROUP BY S-25
for distinct rows S-19
Self join S-30
SEQNUMBER
in COMMENTS table C-51
in CONSTRNT table C-70
in CPRLSRCE table C-131
Sequential access block size B-5
SEQUENTIAL BLOCKSPLIT option,
CONTROL TABLE directive C-83
Sequential blocksplits E-19
Sequential cache E-16
Sequential inserts C-83
SEQUENTIAL option, CONTROL TABLE
directive C-82
Serial writes
compared to parallel S-32
description of S-32
SERIALIZABLE, ISO Isolation Level S-70
SERIALWRITES file attribute S-32
SERIALWRITES, in FILES table F-27
Session
ending E-13
Session options
displaying S-53
resetting R-19
saving in file S-2
setting S-39
SESSION option, SAVE command S-3
SET DEFINE command S-32
SET DEFMODE command S-34
SET LAYOUT command S-34
Set operation
DELETE statement D-39
UPDATE statement U-3
SET PARAM command
COMPUTE_TIMESTAMP
function C-62
CURRENT_TIMESTAMP
function C-174, S-35