SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-32
S
STDDEV function
DISTINCT clause within 8-171
examples of 8-172
statistical definition of 8-171
syntax diagram of 8-171
STORE BY clause, syntax description 7-23
Stored procedure statements
CALL 2-53
CREATE PROCEDURE 2-88
DROP PROCEDURE 2-182
Stored text
reserved words B-1
SQL/MP restrictions 1-32
Stream timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-372
static
CONTROL QUERY DEFAULT
statement setting 2-60
SYSTEM_DEFAULTS table 10-81
STREAM_TIMEOUT default 10-81
String literals 6-64
String value expression
examples of 6-42
syntax diagram of 6-41
struct 3-67
Subquery
correlated 6-92
, 6-114
description of 6-112
inner query 6-113
outer query 6-113
outer reference 6-114
row
BETWEEN predicate 6-86
comparison predicate 6-88
IN predicate 6-94
NULL predicate 6-99
quantified comparison
predicate 6-101
scalar
BETWEEN predicate 6-86
comparison predicate 6-88
DELETE statement 2-165, 2-388
IN predicate 6-94
NULL predicate 6-99
quantified comparison
predicate 6-101
UPDATE statement 2-387
table 6-94
SUBSTRING function
examples of 8-175
operand requirements 8-174
syntax diagram of 8-174
SUM function
DISTINCT clause within 8-176
examples of 8-177
syntax diagram of 8-176
Super ID, privileges for executing
utilities 5-2
SYSKEY
description of 6-63
INVOKE statement 3-66
system-clustered tables 2-286
SYSKEY column, from INVOKE
directive 3-66
SYSKEY, column 2-350
System 10-11
System-clustered tables 2-286
SYSTEM_DEFAULTS metadata
table 10-37
SYSTEM_DEFAULTS table
character set 10-60
constraint droppable option 10-50
data types 10-51, 10-52
examples of 10-83
histograms 10-52
isolation level 10-56
locking 10-57
nonaudited tables 10-60
object naming 10-60