SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-28
S
SCHEMA default 10-61
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-170
FETCH use of 3-41
OPEN use of 3-72
PREPARE use of 2-225
SCRATCH_DISKS default 10-75
SCRATCH_DISKS_EXCLUDED
default 10-75
SCRATCH_DISKS_PREFERRED
default 10-75
SCRATCH_FREESPACE_THRESHOLD_P
ERCENT default 10-75
Search condition
Boolean operators within 6-106
CASE expression use of 9-17
DELETE statement use of 2-149
description of 6-109
examples of 6-107
predicate within 6-106
syntax diagram of 6-106
UPDATE statement use of 2-301
SECOND function
examples of 9-162
syntax diagram of 9-162
SELECT access privilege 2-198, 2-231
SELECT ROW COUNT statement
considerations 2-275
examples of 2-276
limitations of 2-275
syntax diagram of 2-275
SELECT statement
access options 2-256
authorization requirements 2-259
compound statements 3-15
DISTINCT clause 2-246
embedded delete 2-249
embedded update 2-249
FROM clause 2-247
FROM clause, limits C-1
GROUP BY clause 2-255, 2-263
HAVING clause 2-256
joined table within 2-250
lock modes 2-257
MXCI examples of 2-267
ORDER BY clause 2-258, 2-263
Publish/Subscribe examples of 2-273
RETURN list 2-249
select list elements 2-246
SEQUENCE BY clause 2-255
simple table within 2-252
SKIP CONFLICT access 2-257
stream access limitations 2-260
STREAM clause 2-248
syntax diagram of 2-242
table reference within 2-247
TRANSPOSE clause 2-254
union operation within 2-257, 2-263
views and 2-259
WHERE clause 2-253
SELECT statement (embedded)
C examples of 2-272
COBOL examples of 2-273
INTO clause 2-246
syntax diagram of 2-242
table reference within 2-246
SEQUENCE 10-28
SEQUENCE BY clause