SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-3
B
AUDITCOMPRESS file
attribute (continued)
CREATE TABLE use of 8-3
syntax diagram of 8-3
Audited tables
CREATE TABLE considerations 2-88
DELETE considerations 2-115
INSERT considerations 2-156
transaction management 1-13
UPDATE considerations 2-239
Authorization ID 1-5
AVG function
DISTINCT clause use of 9-16
examples of 9-17
operand requirements 9-16
syntax diagram of 9-16
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-28
MXCI examples of 2-27
syntax diagram of 2-27
BETWEEN predicate
examples of 6-86
logical equivalents 6-85
operand requirements 6-85
syntax diagram of 6-85
BLOCKSIZE file attribute
size recommendations 8-4
syntax diagram of 8-4
Boolean operators
NOT, AND, OR 6-105
search condition use of 6-105
Break key 1-4, 4-42
BROWSE access 1-7, 1-28
C
CACHE_HISTOGRAMS default 10-40
CALL statement
examples of 2-31
syntax diagram of 2-29
CASE expression
data type of 9-19
examples of 9-20
searched CASE form 9-18
simple CASE form 9-18
syntax diagram of 9-18
CAST expression
data type conversion 9-22
examples of 9-23
syntax diagram of 9-22
valid type combinations 9-22
CATALOG default 10-47
Catalogs
CREATE CATALOG statement 2-52
DECLARE CATALOG declaration 3-21
DROP CATALOG statement 2-119
SET CATALOG statement 2-212
SQL/MP 6-2
SQL/MX 6-2
CATSYS metadata table 10-12
CAT_REFERENCES metadata table 10-8
CD command
examples of 4-7
path name within 4-7
syntax diagram of 4-7
CEILING function
examples of 9-24
syntax diagram of 9-24
CHAR data type 6-20, 6-21
CHAR function
examples of 9-25