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

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-5
C
Cluster sampling 7-10
Clustering key
description of 6-57
limits C-2
NONDROPPABLE PRIMARY KEY
specification 2-84
STORE BY clause 7-22
STORE BY clause, CREATE
TABLE 2-87
system-defined SYSKEY 6-60
CODE_VALUE function, syntax diagram
of 9-27
Collations
description of 6-6
SQL/MP considerations 1-31
COLS metadata table 10-13
Columns
column reference 6-7
default values 6-8
qualified name 6-7
COL_PRIVILEGES metadata table 10-17
Comment (--), examples of 1-4
Comments, host language 3-38
COMMIT WORK statement
C examples of 2-34
COBOL examples of 2-35
constraints check 2-33
MXCI examples of 2-33
syntax diagram of 2-33
Comparable data types 2-174, 6-17
Comparison predicates
comparison operators 6-85
data conversions 6-86
examples of 6-87
operand requirements 6-85
syntax diagram of 6-85
Compatible data types 2-174, 6-17
COMPILERCONTROLS function
examples of 9-29
syntax diagram of 9-28
Compound statements
BEGIN...END statement 3-14
IF statement 3-61
SET (assignment) statement 3-76
CONCAT function
examples of 9-32
syntax diagram of 9-31
Concatenation operator (||)
description of 9-31
examples of 9-25, 9-32
Concurrency
DDL_LOCKS metadata table 10-18
DELETE statement 2-118, 2-119
description of 1-15
import utility 5-37
INSERT statement 2-172, 2-173
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS default 10-48
MODIFY utility 5-85
MXCI sessions 4-37
NUMBER_OF_USERS default 10-62
SELECT statement 2-212, 2-214
SET TRANSACTION statement 2-241,
2-244
UPDATE statement 2-254, 2-256
VERIFY utility 5-119
Constraints
ALTER TABLE use of 2-10
CHECK 6-9
description of 6-9
implemented with indexes 2-21
limits C-1
NOT NULL 6-9
PRIMARY KEY 6-9
privileges 2-21
references column 2-15, 2-19, 6-9
REFERENTIAL INTEGRITY 6-9
UNIQUE 6-9
CONTROL QUERY DEFAULT statement
attributes 10-33