SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-28
S
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-202
FETCH use of 3-41
OPEN use of 3-72
PREPARE use of 2-300
SCRATCH_DISKS default 10-76
SCRATCH_DISKS_EXCLUDED
default 10-76
SCRATCH_DISKS_PREFERRED
default 10-76
SCRATCH_FREESPACE_THRESHOLD_P
ERCENT default 10-76
Search condition
Boolean operators within 6-108
CASE expression use of 8-17
DELETE statement use of 2-165
description of 6-112
examples of 6-109
predicate within 6-108
syntax diagram of 6-108
UPDATE statement use of 2-389
SECOND function
examples of 8-167
syntax diagram of 8-167
SELECT access privilege 2-241, 2-317
SELECT ROW COUNT statement
considerations 2-363
examples of 2-364
limitations of 2-363
syntax diagram of 2-363
SELECT statement
access options 2-344
authorization requirements 2-347
compound statements 3-15
DISTINCT clause 2-334
embedded delete 2-337
embedded update 2-337
FROM clause 2-335
FROM clause, limits C-1
GROUP BY clause 2-343, 2-351
HAVING clause 2-344
joined table within 2-338
lock modes 2-345
MXCI examples of 2-355
ORDER BY clause 2-346, 2-351
Publish/Subscribe examples of 2-361
RETURN list 2-337
select list elements 2-334
SEQUENCE BY clause 2-343
simple table within 2-340
SKIP CONFLICT access 2-345
stream access limitations 2-348
STREAM clause 2-336
syntax diagram of 2-330
table reference within 2-335
TRANSPOSE clause 2-342
union operation within 2-345, 2-351
views and 2-347
WHERE clause 2-341
SELECT statement (embedded)
C examples of 2-360
COBOL examples of 2-361
INTO clause 2-334
syntax diagram of 2-330
table reference within 2-334
SEQUENCE 10-28
SEQUENCE BY clause
examples of 7-21
SELECT statement use of 7-19
syntax diagram of 7-19
Sequence functions
summary of 8-7
DIFF1 8-59