SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-27
S
C examples of 2-254
COBOL examples of 2-254
MXCI examples of 2-253
syntax diagram of 2-253
ROUTINES metadata table 10-28
Row value constructor
BETWEEN predicate use of 6-86
comparison predicates use of 6-88
IN predicate use of 6-94
NULL predicate use of 6-99
quantified comparison predicates use
of 6-101
ROWS SINCE function
examples of 9-149
syntax diagram of 9-148
Rowsets
DELETE statement 2-151, 2-153
expressions 6-55
GET DESCRIPTOR items 3-50
INSERT statement 2-218, 2-220
predicates 6-104
search condition 6-108
SELECT statement
FROM clause 2-265
HAVING clause 2-269
host variables 2-260
ROWSET FOR clause 2-258
search condition 2-266
size 2-265
SET DESCRIPTOR items 3-80
default 3-80
triggers 2-138, 2-140
UPDATE statement 2-311/2-312, 2-314
RPAD function
examples of 9-150
syntax diagram of 9-150
RTRIM function
examples of 9-152
syntax diagram of 9-152
RUNNINGAVG function
equivalent definition 9-153
examples of 9-153
syntax diagram of 9-153
RUNNINGCOUNT function
examples of 9-155
syntax diagram of 9-155
RUNNINGMAX function
examples of 9-157
syntax diagram of 9-157
RUNNINGMIN function
examples of 9-159
syntax diagram of 9-159
RUNNINGSTDDEV function
equivalent definition 9-161
examples of 9-161
syntax diagram of 9-161
RUNNINGSUM function
examples of 9-163
syntax diagram of 9-163
RUNNINGVARIANCE function
examples of 9-165
syntax diagram of 9-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-154
description of 1-15
UPD_SAVEPOINT_ON_ERROR
default 10-80