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-27
S
NULL predicate use of 6-99
quantified comparison predicates use
of 6-101
ROWS SINCE function
examples of 8-149
syntax diagram of 8-148
Rowsets
DELETE statement 2-163, 2-165
expressions 6-55
GET DESCRIPTOR items 3-50
INSERT statement 2-253, 2-255
predicates 6-104
search condition 6-110
SELECT statement
FROM clause 2-340
HAVING clause 2-344
host variables 2-335
ROWSET FOR clause 2-333
search condition 2-341
size 2-340
SET DESCRIPTOR items 3-80
default 3-80
triggers 2-150, 2-152
UPDATE statement 2-386/2-387, 2-389
RPAD function
examples of 8-150
syntax diagram of 8-150
RTRIM function
examples of 8-152
syntax diagram of 8-152
RUNNINGAVG function
equivalent definition 8-153
examples of 8-153
syntax diagram of 8-153
RUNNINGCOUNT function
examples of 8-155
syntax diagram of 8-155
RUNNINGMAX function
examples of 8-157
syntax diagram of 8-157
RUNNINGMIN function
examples of 8-159
syntax diagram of 8-159
RUNNINGSTDDEV function
equivalent definition 8-161
examples of 8-161
syntax diagram of 8-161
RUNNINGSUM function
examples of 8-163
syntax diagram of 8-163
RUNNINGVARIANCE function
examples of 8-165
syntax diagram of 8-165
S
SAMPLE clause
cluster sampling 7-11
examples of 7-12
SELECT statement use of 7-9
syntax diagram of 7-9
Sample database
description of D-1
entity/relationship diagram D-2
table schema D-3
Sampling, clusters 7-11
Savepoints
DELETE statement 2-166
description of 1-14
UPD_SAVEPOINT_ON_ERROR
default 10-78
SAVE_DROPPED_TABLE_DDL
default 10-82
Scale 6-53
SCHEMA default 10-61
Schemas, description of 6-105
SCHEMATA metadata table 10-10
SCHEMA_REPLICAS metadata
table 10-11
Scope
ALLOCATE CURSOR use of 3-3