SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-5
C
CLOSE statement (continued)
static and dynamic forms 3-11
syntax diagram of 3-11
Cluster sampling 7-10
Clustering key
description of 6-60
limits C-2
NONDROPPABLE PRIMARY KEY
specification 2-82
STORE BY clause 7-22
STORE BY clause, CREATE
TABLE 2-86
system-defined SYSKEY 6-63
CODE_VALUE function, syntax diagram
of 9-27
Collations
description of 6-6
SQL/MP considerations 1-31
COLS metadata table 10-14
Columns
column reference 6-7
default values 6-8
qualified name 6-7
COL_PRIVILEGES metadata table 10-18
Comment (--), examples of 1-4
Comments, host language 3-38
COMMIT WORK statement
C examples of 2-32
COBOL examples of 2-33
constraints check 2-31
MXCI examples of 2-31
syntax diagram of 2-31
Comparable data types 2-175, 6-17
Comparison predicates
comparison operators 6-88
data conversions 6-89
examples of 6-90
operand requirements 6-88
syntax diagram of 6-88
Compatible data types 2-175, 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-19
DELETE statement 2-119, 2-120
description of 1-15
import utility 5-41
INSERT statement 2-173, 2-174
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS default 10-54
MODIFY utility 5-89
MXCI sessions 4-48
NUMBER_OF_USERS default 10-67
SELECT statement 2-213, 2-215
SET TRANSACTION statement 2-244,
2-247
UPDATE statement 2-257, 2-259
VERIFY utility 5-126
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