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

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-26
S
Schemas, description of 6-104
SCHEMATA metadata table 10-9
SCHEMA_REPLICAS metadata table 10-9
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-135
FETCH use of 3-41
OPEN use of 3-73
PREPARE use of 2-164
SCRATCH_DISKS default 10-60
SCRATCH_DISKS_EXCLUDED
default 10-60
SCRATCH_DISKS_PREFERRED
default 10-60
SCRATCH_FREESPACE_THRESHOLD_P
ERCENT default 10-60
Search condition
Boolean operators within 6-105
CASE expression use of 9-19
DELETE statement use of 2-112
description of 6-108
examples of 6-106
predicate within 6-105
syntax diagram of 6-105
UPDATE statement use of 2-235
SECOND function
examples of 9-140
syntax diagram of 9-140
SELECT access privilege 2-141, 2-170
SELECT statement
access options 2-192
authorization requirements 2-195
compound statements 3-15
DISTINCT clause 2-182
SELECT statement (continued)
embedded delete 2-185
embedded update 2-185
FROM clause 2-183
GROUP BY clause 2-191, 2-199
HAVING clause 2-191
joined table within 2-186
lock modes 2-193
MXCI examples of 2-203
ORDER BY clause 2-194, 2-199
Publish/Subscribe examples of 2-209
RETURN list 2-185
select list elements 2-182
SEQUENCE BY clause 2-191
simple table within 2-188
SKIP CONFLICT access 2-193
stream access limitations 2-196
STREAM clause 2-184
syntax diagram of 2-178
table reference within 2-183
TRANSPOSE clause 2-190
union operation within 2-193, 2-200
views and 2-195
WHERE clause 2-189
SELECT statement (embedded)
C examples of 2-208
COBOL examples of 2-209
INTO clause 2-182
syntax diagram of 2-178
table reference within 2-182
SEQUENCE BY clause
examples of 7-20
SELECT statement use of 7-18
syntax diagram of 7-18
Sequence functions
summary of 9-7
DIFF1 9-49
DIFF2 9-52
LASTNOTNULL 9-67