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

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-27
S
ROWS SINCE function (continued)
syntax diagram of 9-130
Rowsets
DELETE statement 2-117, 2-118
expressions 6-55
GET DESCRIPTOR items 3-50
INSERT statement 2-170, 2-172
predicates 6-104
search condition 6-108
SELECT statement
FROM clause 2-208
HAVING clause 2-212
host variables 2-203
ROWSET FOR clause 2-201
search condition 2-209
size 2-208
SET DESCRIPTOR items 3-80
default 3-80
triggers 2-108, 2-109
UPDATE statement 2-254/2-255, 2-257
RPAD function
examples of 9-132
syntax diagram of 9-132
RTRIM function
examples of 9-134
syntax diagram of 9-134
RUNNINGAVG function
equivalent definition 9-135
examples of 9-135
syntax diagram of 9-135
RUNNINGCOUNT function
examples of 9-137
syntax diagram of 9-137
RUNNINGMAX function
examples of 9-139
syntax diagram of 9-139
RUNNINGMIN function
examples of 9-141
syntax diagram of 9-141
RUNNINGSTDDEV function
equivalent definition 9-143
examples of 9-143
syntax diagram of 9-143
RUNNINGSUM function
examples of 9-145
syntax diagram of 9-145
RUNNINGVARIANCE function
examples of 9-147
syntax diagram of 9-147
S
SAMPLE clause
cluster sampling 7-10
examples of 7-11
SELECT statement use of 7-8
syntax diagram of 7-8
Sample database
description of D-1
entity/relationship diagram D-2
table schema D-3
Sampling, clusters 7-10
Savepoints
DELETE statement 2-119
description of 1-13
INSERT statement 2-173
UPDATE statement 2-258
UPD_SAVEPOINT_ON_ERROR
default 10-74
SAVE_DROPPED_TABLE_DDL
default 10-78
Scale 6-53
SCHEMA default 10-58
Schemas, description of 6-105
SCHEMATA metadata table 10-10
SCHEMA_REPLICAS metadata
table 10-11
Scope
ALLOCATE CURSOR use of 3-3
ALLOCATE DESCRIPTOR use of 3-6