SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-28
S
Scope (continued)
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-139
FETCH use of 3-41
OPEN use of 3-72
PREPARE use of 2-184
SCRATCH_DISKS default 10-72
SCRATCH_DISKS_EXCLUDED
default 10-72
SCRATCH_DISKS_PREFERRED
default 10-72
SCRATCH_FREESPACE_THRESHOLD_P
ERCENT default 10-72
Search condition
Boolean operators within 6-106
CASE expression use of 9-17
DELETE statement use of 2-118
description of 6-109
examples of 6-107
predicate within 6-106
syntax diagram of 6-106
UPDATE statement use of 2-257
SECOND function
examples of 9-149
syntax diagram of 9-149
SELECT access privilege 2-162, 2-190
SELECT ROW COUNT statement
considerations 2-231
examples of 2-232
limitations of 2-231
syntax diagram of 2-231
SELECT statement
access options 2-212
authorization requirements 2-215
compound statements 3-15
SELECT statement (continued)
DISTINCT clause 2-202
embedded delete 2-205
embedded update 2-205
FROM clause 2-203
FROM clause, limits C-1
GROUP BY clause 2-211, 2-219
HAVING clause 2-211
joined table within 2-206
lock modes 2-213
MXCI examples of 2-223
ORDER BY clause 2-214, 2-219
Publish/Subscribe examples of 2-229
RETURN list 2-205
select list elements 2-202
SEQUENCE BY clause 2-211
simple table within 2-208
SKIP CONFLICT access 2-213
stream access limitations 2-216
STREAM clause 2-204
syntax diagram of 2-198
table reference within 2-203
TRANSPOSE clause 2-210
union operation within 2-213, 2-219
views and 2-215
WHERE clause 2-209
SELECT statement (embedded)
C examples of 2-228
COBOL examples of 2-229
INTO clause 2-202
syntax diagram of 2-198
table reference within 2-202
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-48