SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-3
B
AUDITCOMPRESS file
attribute (continued)
ALTER TABLE use of 8-3
CREATE TABLE use of 8-3
syntax diagram of 8-3
Audited tables
CREATE TABLE considerations 2-94
DELETE considerations 2-120
INSERT considerations 2-175
transaction management 1-15
UPDATE considerations 2-258
Authorization ID 1-5
AUTOMATIC_RECOMPILATION
default 10-69
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-27
C examples of 2-28
COBOL examples of 2-29
MXCI examples of 2-28
syntax diagram of 2-27
BETWEEN predicate
examples of 6-84
logical equivalents 6-83
operand requirements 6-83
syntax diagram of 6-83
BLOCKSIZE file attribute
size recommendations 8-4
syntax diagram of 8-4
Boolean operators
Boolean operators (continued)
NOT, AND, OR 6-103
search condition use of 6-103
Break key 1-5, 4-46
BROWSE access 1-7, 1-30
C
CACHE_HISTOGRAMS default 10-43
CACHE_HISTOGRAMS_REFRESH_INTE
RVALS default 10-43
CALL statement
examples of 2-31
syntax diagram of 2-29
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-51
Catalogs
CREATE CATALOG statement 2-54
DECLARE CATALOG declaration 3-21
DROP CATALOG statement 2-124
SET CATALOG statement 2-231
SQL/MP 6-3
SQL/MX 6-3
CATSYS metadata table 10-13
CAT_REFERENCES metadata table 10-9
CD command
examples of 4-7
path name within 4-7
syntax diagram of 4-7
CEILING function
examples of 9-22