SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-26
S
REVOKE statement
authorization and availability
requirements 2-191
examples of 2-191
syntax diagram of 2-189
WITH GRANT OPTION 2-189
RIGHT function
examples of 9-123
syntax diagram of 9-123
RIGHT join, description of 2-207
RI_UNIQUE_USAGE metadata table 10-22
ROLLBACK WORK statement
C examples of 2-196
COBOL examples of 2-196
MXCI examples of 2-195
syntax diagram of 2-195
ROUTINES metadata table 10-23
Row value constructor
BETWEEN predicate use of 6-83
comparison predicates use of 6-85
IN predicate use of 6-91
NULL predicate use of 6-96
quantified comparison predicates use
of 6-98
ROWS SINCE function
examples of 9-125
syntax diagram of 9-124
Rowsets
DELETE statement 2-116, 2-117
expressions 6-52
GET DESCRIPTOR items 3-50
INSERT statement 2-169, 2-171
predicates 6-101
search condition 6-105
SELECT statement
FROM clause 2-207
HAVING clause 2-211
host variables 2-202
ROWSET FOR clause 2-200
search condition 2-208
Rowsets (continued)
size 2-207
SET DESCRIPTOR items 3-80
default 3-80
triggers 2-107, 2-109
UPDATE statement 2-251/2-252, 2-254
RPAD function
examples of 9-126
syntax diagram of 9-126
RTRIM function
examples of 9-127
syntax diagram of 9-127
RUNNINGAVG function
equivalent definition 9-128
examples of 9-128
syntax diagram of 9-128
RUNNINGCOUNT function
examples of 9-130
syntax diagram of 9-130
RUNNINGMAX function
examples of 9-132
syntax diagram of 9-132
RUNNINGMIN function
examples of 9-134
syntax diagram of 9-134
RUNNINGSTDDEV function
equivalent definition 9-136
examples of 9-136
syntax diagram of 9-136
RUNNINGSUM function
examples of 9-138
syntax diagram of 9-138
RUNNINGVARIANCE function
examples of 9-140
syntax diagram of 9-140
S
SAMPLE clause
cluster sampling 7-10