SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-32
S
SET STATISTICS command 4-68
SQL/MP histogram tables 10-83
stored in PARTITIONS table 10-24
UPDATE STATISTICS statement
considerations 2-314
examples of 2-318
syntax diagram 2-310
STDDEV function
DISTINCT clause within 9-166
examples of 9-167
statistical definition of 9-166
syntax diagram of 9-166
STORE BY clause, syntax description 7-23
Stored procedure statements
CALL 2-44
CREATE PROCEDURE 2-78
DROP PROCEDURE 2-158
Stored text
reserved words B-1
SQL/MP restrictions 1-31
Stream timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-284
static
CONTROL QUERY DEFAULT
statement setting 2-51
SYSTEM_DEFAULTS table 10-80
STREAM_TIMEOUT default 10-80
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
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-149, 2-300
IN predicate 6-94
NULL predicate 6-99
quantified comparison
predicate 6-101
UPDATE statement 2-299
table 6-94
SUBSTRING function
examples of 9-170
operand requirements 9-169
syntax diagram of 9-169
SUM function
DISTINCT clause within 9-171
examples of 9-172
syntax diagram of 9-171
Super ID, privileges for executing
utilities 5-3
SYSKEY
description of 6-63
INVOKE statement 3-66
system-clustered tables 5-85
SYSKEY column, from INVOKE
directive 3-66
SYSKEY, column 2-262
System 10-11
System-clustered tables 5-85
SYSTEM_DEFAULTS metadata
table 10-37
SYSTEM_DEFAULTS table
character set 10-60
constraint droppable option 10-50
data types 10-51, 10-52