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

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-27
S
SAMPLE clause (continued)
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-118
description of 1-13
INSERT statement 2-172
UPDATE statement 2-255
UPD_SAVEPOINT_ON_ERROR
default 10-69
SAVE_DROPPED_TABLE_DDL
default 10-72
Scale 6-50
SCHEMA default 10-51
Schemas, description of 6-102
SCHEMATA metadata table 10-10
SCHEMA_REPLICAS metadata
table 10-10
Scope
ALLOCATE CURSOR use of 3-3
ALLOCATE DESCRIPTOR use of 3-6
CLOSE use of 3-11
DEALLOCATE DESCRIPTOR use
of 3-16
DEALLOCATE PREPARE use of 3-18
DECLARE CURSOR use of 3-24
DESCRIBE use of 3-35
EXECUTE use of 2-138
FETCH use of 3-41
OPEN use of 3-72
PREPARE use of 2-183
SCRATCH_DISKS default 10-67
SCRATCH_DISKS_EXCLUDED
default 10-67
SCRATCH_DISKS_PREFERRED
default 10-67
SCRATCH_FREESPACE_THRESHOLD_P
ERCENT default 10-67
Search condition
Boolean operators within 6-103
CASE expression use of 9-17
DELETE statement use of 2-117
description of 6-106
examples of 6-104
predicate within 6-103
syntax diagram of 6-103
UPDATE statement use of 2-254
SECOND function
examples of 9-142
syntax diagram of 9-142
SELECT access privilege 2-161, 2-189
SELECT statement
access options 2-211
authorization requirements 2-214
compound statements 3-15
DISTINCT clause 2-201
embedded delete 2-204
embedded update 2-204
FROM clause 2-202
FROM clause, limits C-1
GROUP BY clause 2-210, 2-218
HAVING clause 2-210
joined table within 2-205
lock modes 2-212
MXCI examples of 2-222
ORDER BY clause 2-213, 2-218
Publish/Subscribe examples of 2-228
RETURN list 2-204
select list elements 2-201
SEQUENCE BY clause 2-210
simple table within 2-207
SKIP CONFLICT access 2-212
stream access limitations 2-215
STREAM clause 2-203