SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-28
S
SAVE_DROPPED_TABLE_DDL
default 10-84
Scale 6-53
SCHEMA default 10-62
Schemas, description of 6-105
SCHEMATA metadata table 10-10
SCHEMA_REPLICAS metadata
table 10-11
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-177
FETCH use of 3-41
OPEN use of 3-72
PREPARE use of 2-237
SCRATCH_DISKS default 10-78
SCRATCH_DISKS_EXCLUDED
default 10-78
SCRATCH_DISKS_PREFERRED
default 10-78
SCRATCH_FREESPACE_THRESHOLD_P
ERCENT default 10-78
Search condition
Boolean operators within 6-106
CASE expression use of 9-17
DELETE statement use of 2-153
description of 6-109
examples of 6-107
predicate within 6-106
syntax diagram of 6-106
UPDATE statement use of 2-314
SECOND function
examples of 9-167
syntax diagram of 9-167
SELECT access privilege 2-206, 2-243
SELECT ROW COUNT statement
considerations 2-288
examples of 2-289
limitations of 2-288
syntax diagram of 2-288
SELECT statement
access options 2-269
authorization requirements 2-272
compound statements 3-15
DISTINCT clause 2-259
embedded delete 2-262
embedded update 2-262
FROM clause 2-260
FROM clause, limits C-1
GROUP BY clause 2-268, 2-276
HAVING clause 2-269
joined table within 2-263
lock modes 2-270
MXCI examples of 2-280
ORDER BY clause 2-271, 2-276
Publish/Subscribe examples of 2-286
RETURN list 2-262
select list elements 2-259
SEQUENCE BY clause 2-268
simple table within 2-265
SKIP CONFLICT access 2-270
stream access limitations 2-273
STREAM clause 2-261
syntax diagram of 2-255
table reference within 2-260
TRANSPOSE clause 2-267
union operation within 2-270, 2-276
views and 2-272
WHERE clause 2-266
SELECT statement (embedded)
C examples of 2-285
COBOL examples of 2-286
INTO clause 2-259
syntax diagram of 2-255