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

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-3
B
ATAN2 function
examples of 9-13
syntax diagram of 9-13
ATTEMPT_ASYNCHRONOUS_ACCESS
default 10-68
ATTEMPT_ESP_PARALLELISM
default 10-68
AUDITCOMPRESS file attribute
ALTER TABLE use of 8-3
CREATE TABLE use of 8-3
syntax diagram of 8-3
Audited tables
CREATE TABLE considerations 2-114
DELETE considerations 2-157
INSERT considerations 2-225
transaction management 1-17
UPDATE considerations 2-318
Authorization ID 1-6
AUTOMATIC_RECOMPILATION
default 10-80
AVG function
DISTINCT clause use of 9-14
examples of 9-15
operand requirements 9-14
syntax diagram of 9-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-44
C examples of 2-45
COBOL examples of 2-45
MXCI examples of 2-44
syntax diagram of 2-44
BETWEEN predicate
examples of 6-87
logical equivalents 6-86
operand requirements 6-86
syntax diagram of 6-86
BLOCKSIZE file attribute
size recommendations 8-4
syntax diagram of 8-4
Boolean operators
NOT, AND, OR 6-106
search condition use of 6-106
Break key 1-6, 4-57
BROWSE access 1-9, 1-32
C
CACHE_HISTOGRAMS default 10-53
CACHE_HISTOGRAMS_REFRESH_INTE
RVALS default 10-53
CALL statement
examples of 2-48
syntax diagram of 2-46
CASE expression
data type of 9-17
examples of 9-18
searched CASE form 9-16
simple CASE form 9-16
syntax diagram of 9-16
CAST expression
data type conversion 9-20
examples of 9-21
syntax diagram of 9-20
valid type combinations 9-20
CATALOG default 10-62
Catalogs
CREATE CATALOG statement 2-70
DECLARE CATALOG declaration 3-21
DROP CATALOG statement 2-163
SET CATALOG statement 2-291
SQL/MP 6-3
SQL/MX 6-3
CATSYS metadata table 10-15
CAT_REFERENCES metadata table 10-9
CD command