SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-30
S
Statistics (continued)
examples of 2-252
syntax diagram 2-245
STDDEV function
DISTINCT clause within 9-147
examples of 9-148
statistical definition of 9-147
syntax diagram of 9-147
STORE BY clause, syntax description 7-22
Stored procedure statements
CALL 2-28
CREATE PROCEDURE 2-61
DROP PROCEDURE 2-122
Stored text
reserved words B-1
SQL/MP restrictions 1-29
Stream timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-218
static
CONTROL QUERY DEFAULT
statement setting 2-35
SYSTEM_DEFAULTS table 10-65
STREAM_TIMEOUT default 10-65
String literals 6-62
String value expression
examples of 6-40
syntax diagram of 6-39
struct 3-68
Subquery
correlated 6-91, 6-110
description of 6-108
inner query 6-109
outer query 6-109
outer reference 6-110
row
BETWEEN predicate 6-85
comparison predicate 6-87
IN predicate 6-93
NULL predicate 6-98
Subquery (continued)
quantified comparison
predicate 6-100
scalar
BETWEEN predicate 6-85
comparison predicate 6-87
DELETE statement 2-112, 2-234
IN predicate 6-93
NULL predicate 6-98
quantified comparison
predicate 6-100
UPDATE statement 2-233
table 6-93
SUBSTRING function
examples of 9-151
operand requirements 9-150
syntax diagram of 9-150
SUM function
DISTINCT clause within 9-152
examples of 9-153
syntax diagram of 9-152
Super ID, privileges for executing
utilities 5-2
SYSKEY
description of 6-61
INVOKE statement 3-67
system-clustered tables 5-53
SYSKEY column, from INVOKE
directive 3-67
SYSKEY, column 2-198
System-clustered tables 5-53
SYSTEM_DEFAULTS metadata
table 10-29
SYSTEM_DEFAULTS table
constraint droppable option 10-39
data types 10-39, 10-40
examples of 10-67
histograms 10-40
isolation level 10-44
locking 10-45
national character set 10-46