SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-25
S
Row value constructor (continued)
comparison predicates use of 6-87
IN predicate use of 6-93
NULL predicate use of 6-98
quantified comparison predicates use
of 6-100
ROWS SINCE function
examples of 9-123
syntax diagram of 9-122
Rowsets
DELETE statement 2-111, 2-112
expressions 6-53
GET DESCRIPTOR items 3-51
INSERT statement 2-150, 2-152
predicates 6-103
search condition 6-107
SELECT statement
FROM clause 2-188
HAVING clause 2-192
host variables 2-183
ROWSET FOR clause 2-181
search condition 2-189
size 2-188
SET DESCRIPTOR items 3-81
default 3-81
triggers 2-102, 2-103
UPDATE statement 2-232/2-233, 2-235
RPAD function
examples of 9-124
syntax diagram of 9-124
RTRIM function
examples of 9-125
syntax diagram of 9-125
RUNNINGAVG function
equivalent definition 9-126
examples of 9-126
syntax diagram of 9-126
RUNNINGCOUNT function
examples of 9-128
syntax diagram of 9-128
RUNNINGMAX function
examples of 9-130
syntax diagram of 9-130
RUNNINGMIN function
examples of 9-132
syntax diagram of 9-132
RUNNINGSTDDEV function
equivalent definition 9-134
examples of 9-134
syntax diagram of 9-134
RUNNINGSUM function
examples of 9-136
syntax diagram of 9-136
RUNNINGVARIANCE function
examples of 9-138
syntax diagram of 9-138
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-113
description of 1-11
DISPLAY_EXPLAIN command 4-17
INSERT statement 2-153
UPDATE statement 2-236
UPD_SAVEPOINT_ON_ERROR
default 10-62
SAVE_DROPPED_TABLE_DDL
default 10-65
Scale 6-51
SCHEMA default 10-48