SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-32
S
Statistics (continued)
SET STATISTICS command 4-68
SQL/MP histogram tables 10-80
stored in PARTITIONS table 10-22
UPDATE STATISTICS statement
considerations 2-270
examples of 2-274
syntax diagram 2-266
STDDEV function
DISTINCT clause within 9-153
examples of 9-154
statistical definition of 9-153
syntax diagram of 9-153
STORE BY clause, syntax description 7-22
Stored procedure statements
CALL 2-27
CREATE PROCEDURE 2-61
DROP PROCEDURE 2-127
Stored text
reserved words B-1
SQL/MP restrictions 1-30
Stream timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-240
static
CONTROL QUERY DEFAULT
statement setting 2-34
SYSTEM_DEFAULTS table 10-77
STREAM_TIMEOUT default 10-77
String literals 6-64
String value expression
examples of 6-42
syntax diagram of 6-41
struct 3-67
Subquery
correlated 6-92, 6-111
description of 6-109
inner query 6-110
outer query 6-110
outer reference 6-111
Subquery (continued)
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-118, 2-256
IN predicate 6-94
NULL predicate 6-99
quantified comparison
predicate 6-101
UPDATE statement 2-255
table 6-94
SUBSTRING function
examples of 9-157
operand requirements 9-156
syntax diagram of 9-156
SUM function
DISTINCT clause within 9-158
examples of 9-159
syntax diagram of 9-158
Super ID, privileges for executing
utilities 5-2
SYSKEY
description of 6-63
INVOKE statement 3-66
system-clustered tables 5-85
SYSKEY column, from INVOKE
directive 3-66
SYSKEY, column 2-218
System-clustered tables 5-85
SYSTEM_DEFAULTS metadata
table 10-34
SYSTEM_DEFAULTS table
character set 10-57
constraint droppable option 10-47