SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-27
S
ROUTINES metadata table 10-27
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-144
syntax diagram of 9-143
Rowsets
DELETE statement 2-148, 2-149
expressions 6-55
GET DESCRIPTOR items 3-50
INSERT statement 2-210, 2-212
predicates 6-104
search condition 6-108
SELECT statement
FROM clause 2-252
HAVING clause 2-256
host variables 2-247
ROWSET FOR clause 2-245
search condition 2-253
size 2-252
SET DESCRIPTOR items 3-80
default 3-80
triggers 2-139, 2-140
UPDATE statement 2-298/2-299, 2-301
RPAD function
examples of 9-145
syntax diagram of 9-145
RTRIM function
examples of 9-147
syntax diagram of 9-147
RUNNINGAVG function
equivalent definition 9-148
examples of 9-148
syntax diagram of 9-148
RUNNINGCOUNT function
examples of 9-150
syntax diagram of 9-150
RUNNINGMAX function
examples of 9-152
syntax diagram of 9-152
RUNNINGMIN function
examples of 9-154
syntax diagram of 9-154
RUNNINGSTDDEV function
equivalent definition 9-156
examples of 9-156
syntax diagram of 9-156
RUNNINGSUM function
examples of 9-158
syntax diagram of 9-158
RUNNINGVARIANCE function
examples of 9-160
syntax diagram of 9-160
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-150
description of 1-14
INSERT statement 2-214
UPDATE statement 2-302
UPD_SAVEPOINT_ON_ERROR
default 10-77
SAVE_DROPPED_TABLE_DDL
default 10-81
Scale 6-53