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-3
B
syntax diagram of 8-13
ATTEMPT_ASYNCHRONOUS_ACCESS
default 10-66
ATTEMPT_ESP_PARALLELISM
default 10-66
AUDITCOMPRESS file attribute
ALTER TABLE use of 9-3
CREATE TABLE use of 9-3
syntax diagram of 9-3
Audited tables
CREATE TABLE considerations 2-126
DELETE considerations 2-169
INSERT considerations 2-260
transaction management 1-16
UPDATE considerations 2-393
Authorization ID 1-5
AUTOMATIC_RECOMPILATION
default 10-78
AVG function
DISTINCT clause use of 8-14
examples of 8-15
operand requirements 8-14
syntax diagram of 8-14
B
BEGIN DECLARE SECTION
C examples of 3-9
COBOL examples of 3-10
C++ examples of 3-9
BEGIN WORK statement
audited tables, effect on 2-52
C examples of 2-53
COBOL examples of 2-53
MXCI examples of 2-52
syntax diagram of 2-52
BETWEEN predicate
examples of 6-87
logical equivalents 6-86
operand requirements 6-86
syntax diagram of 6-86
BLOCKSIZE file attribute
size recommendations 9-4
syntax diagram of 9-4
Boolean operators
NOT, AND, OR 6-108
search condition use of 6-108
Break key 1-5, 4-58
BROWSE access 1-8, 1-32
C
CACHE_HISTOGRAMS default 10-52
CACHE_HISTOGRAMS_REFRESH_INTE
RVALS default 10-52
CALL statement
examples of 2-56
syntax diagram of 2-54
CASE expression
data type of 8-17
examples of 8-18
searched CASE form 8-16
simple CASE form 8-16
syntax diagram of 8-16
CAST expression
data type conversion 8-20
examples of 8-21
syntax diagram of 8-20
valid type combinations 8-20
CATALOG default 10-60
Catalogs
CREATE CATALOG statement 2-78
DECLARE CATALOG declaration 3-21
DROP CATALOG statement 2-180
SET CATALOG statement 2-366
SQL/MP 6-3
SQL/MX 6-3
CATSYS metadata table 10-15
CAT_REFERENCES metadata table 10-9
CD command
examples of 4-8
path name within 4-8