SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-26
S
ROLLBACK WORK statement
C examples of 2-173
COBOL examples of 2-173
MXCI examples of 2-172
syntax diagram of 2-172
ROUTINES metadata table 10-23
Row value constructor
BETWEEN predicate use of 6-82
comparison predicates use of 6-84
IN predicate use of 6-90
NULL predicate use of 6-95
quantified comparison predicates use
of 6-97
ROWS SINCE function
examples of 9-121
syntax diagram of 9-120
Rowsets
DELETE statement 2-110, 2-111
expressions 6-51
GET DESCRIPTOR items 3-49
INSERT statement 2-146, 2-148
predicates 6-100
search condition 6-104
SELECT statement
FROM clause 2-184
HAVING clause 2-188
host variables 2-179
ROWSET FOR clause 2-177
search condition 2-185
size 2-184
SET DESCRIPTOR items 3-79
default 3-79
triggers 2-101, 2-102
UPDATE statement 2-227/2-228, 2-230
RPAD function
examples of 9-122
syntax diagram of 9-122
RTRIM function
examples of 9-123
syntax diagram of 9-123
RUNNINGAVG function
equivalent definition 9-124
examples of 9-124
syntax diagram of 9-124
RUNNINGCOUNT function
examples of 9-126
syntax diagram of 9-126
RUNNINGMAX function
examples of 9-128
syntax diagram of 9-128
RUNNINGMIN function
examples of 9-130
syntax diagram of 9-130
RUNNINGSTDDEV function
equivalent definition 9-132
examples of 9-132
syntax diagram of 9-132
RUNNINGSUM function
examples of 9-134
syntax diagram of 9-134
RUNNINGVARIANCE function
examples of 9-136
syntax diagram of 9-136
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-112
description of 1-13
DISPLAY_EXPLAIN command 4-17