SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-27
S
Savepoints (continued)
INSERT statement 2-149
UPDATE statement 2-231
UPD_SAVEPOINT_ON_ERROR
default 10-64
SAVE_DROPPED_TABLE_DDL
default 10-67
Scale 6-49
SCHEMA default 10-49
Schemas, description of 6-101
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-34
EXECUTE use of 2-132
FETCH use of 3-40
OPEN use of 3-71
PREPARE use of 2-160
SCRATCH_DISKS default 10-62
SCRATCH_DISKS_EXCLUDED
default 10-62
SCRATCH_DISKS_PREFERRED
default 10-62
SCRATCH_FREESPACE_THRESHOLD_P
ERCENT default 10-62
Search condition
Boolean operators within 6-102
CASE expression use of 9-17
DELETE statement use of 2-111
description of 6-105
examples of 6-103
predicate within 6-102
syntax diagram of 6-102
Search condition (continued)
UPDATE statement use of 2-230
SECOND function
examples of 9-138
syntax diagram of 9-138
SELECT access privilege 2-138, 2-166
SELECT statement
access options 2-188
authorization requirements 2-191
compound statements 3-15
DISTINCT clause 2-178
embedded delete 2-181
embedded update 2-181
FROM clause 2-179
FROM clause, limits C-1
GROUP BY clause 2-187, 2-195
HAVING clause 2-187
joined table within 2-182
lock modes 2-189
MXCI examples of 2-199
ORDER BY clause 2-190, 2-195
Publish/Subscribe examples of 2-205
RETURN list 2-181
select list elements 2-178
SEQUENCE BY clause 2-187
simple table within 2-184
SKIP CONFLICT access 2-189
stream access limitations 2-192
STREAM clause 2-180
syntax diagram of 2-174
table reference within 2-179
TRANSPOSE clause 2-186
union operation within 2-189, 2-196
views and 2-191
WHERE clause 2-185
SELECT statement (embedded)
C examples of 2-204
COBOL examples of 2-205
INTO clause 2-178