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

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-5
C
Clustering key (continued)
NONDROPPABLE PRIMARY KEY
specification 2-79
STORE BY clause 7-22
STORE BY clause, CREATE
TABLE 2-82
system-defined SYSKEY 6-61
CODE_VALUE function, syntax diagram
of 9-29
Collations
description of 6-5
SQL/MP considerations 1-30
COLS metadata table 10-12
Columns
column reference 6-6
default values 6-7
qualified name 6-6
COL_PRIVILEGES metadata table 10-16
Comment (--), examples of 1-3
Comments, host language 3-38
COMMIT WORK statement
C examples of 2-33
COBOL examples of 2-34
constraints check 2-32
MXCI examples of 2-32
syntax diagram of 2-32
Comparable data types 2-156, 6-16
Comparison predicates
comparison operators 6-87
data conversions 6-88
examples of 6-89
operand requirements 6-87
syntax diagram of 6-87
Compatible data types 2-156, 6-16
Compound statements
BEGIN...END statement 3-14
IF statement 3-62
SET (assignment) statement 3-77
CONCAT function
examples of 9-31
CONCAT function (continued)
syntax diagram of 9-30
Concatenation operator (||)
description of 9-30
examples of 9-27, 9-31
Concurrency
DDL_LOCKS metadata table 10-17
DELETE statement 2-113, 2-114
description of 1-14
import utility 5-24
INSERT statement 2-153, 2-154
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS default 10-45
MODIFY utility 5-56
MXCI sessions 4-34
NUMBER_OF_USERS default 10-56
SELECT statement 2-193, 2-195
SET TRANSACTION statement 2-223,
2-225
UPDATE statement 2-236, 2-237
VERIFY utility 5-80
Constraints
ALTER TABLE use of 2-11
CHECK 6-8
description of 6-8
implemented with indexes 2-21
NOT NULL 6-8
PRIMARY KEY 6-8
privileges 2-21
references column 2-16, 2-19, 6-8
REFERENTIAL INTEGRITY 6-8
UNIQUE 6-8
CONTROL QUERY DEFAULT statement
attributes 10-31
examples of 2-36
syntax diagram of 2-35
CONTROL QUERY SHAPE statement
examples of 2-43
syntax diagram of 2-37