SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-32
S
QUERYCACHE function 9-134
QUERYCACHEENTRIES
function 9-138
SET STATISTICS command 4-68
SQL/MP histogram tables 10-86
stored in PARTITIONS table 10-25
UPDATE STATISTICS statement
considerations 2-331
examples of 2-335
syntax diagram 2-327
STDDEV function
DISTINCT clause within 9-171
examples of 9-172
statistical definition of 9-171
syntax diagram of 9-171
STORE BY clause, syntax description 7-23
Stored procedure statements
CALL 2-45
CREATE PROCEDURE 2-80
DROP PROCEDURE 2-165
Stored text
reserved words B-1
SQL/MP restrictions 1-32
Stream timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-297
static
CONTROL QUERY DEFAULT
statement setting 2-52
SYSTEM_DEFAULTS table 10-83
STREAM_TIMEOUT default 10-83
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-153, 2-313
IN predicate 6-94
NULL predicate 6-99
quantified comparison
predicate 6-101
UPDATE statement 2-312
table 6-94
SUBSTRING function
examples of 9-175
operand requirements 9-174
syntax diagram of 9-174
SUM function
DISTINCT clause within 9-176
examples of 9-177
syntax diagram of 9-176
Super ID, privileges for executing
utilities 5-3
SYSKEY
description of 6-63
INVOKE statement 3-66
system-clustered tables 5-92
SYSKEY column, from INVOKE
directive 3-66
SYSKEY, column 2-275
System 10-12
System-clustered tables 5-92
SYSTEM_DEFAULTS metadata
table 10-38
SYSTEM_DEFAULTS table