SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-5
C
CLOSE statement (continued)
syntax diagram of 3-11
Cluster sampling 7-10
Clustering key
description of 6-56
limits C-2
NONDROPPABLE PRIMARY KEY
specification 2-79
STORE BY clause 7-22
STORE BY clause, CREATE
TABLE 2-81
system-defined SYSKEY 6-59
CODE_VALUE function, syntax diagram
of 9-27
Collations
description of 6-5
SQL/MP considerations 1-31
COLS metadata table 10-13
Columns
column reference 6-6
default values 6-7
qualified name 6-6
COL_PRIVILEGES metadata table 10-17
Comment (--), examples of 1-4
Comments, host language 3-37
COMMIT WORK statement
C examples of 2-31
COBOL examples of 2-32
constraints check 2-30
MXCI examples of 2-30
syntax diagram of 2-30
Comparable data types 2-151, 6-16
Comparison predicates
comparison operators 6-84
data conversions 6-85
examples of 6-86
operand requirements 6-84
syntax diagram of 6-84
Compatible data types 2-151, 6-16
Compound statements
BEGIN...END statement 3-14
IF statement 3-60
SET (assignment) statement 3-75
CONCAT function
examples of 9-29
syntax diagram of 9-28
Concatenation operator (||)
description of 9-28
examples of 9-25, 9-29
Concurrency
DDL_LOCKS metadata table 10-18
DELETE statement 2-112, 2-113
description of 1-15
import utility 5-26
INSERT statement 2-149, 2-150
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS default 10-46
MODIFY utility 5-60
MXCI sessions 4-34
NUMBER_OF_USERS default 10-57
SELECT statement 2-189, 2-191
SET TRANSACTION statement 2-218,
2-220
UPDATE statement 2-230, 2-232
VERIFY utility 5-84
Constraints
ALTER TABLE use of 2-10
CHECK 6-8
description of 6-8
implemented with indexes 2-20
limits C-1
NOT NULL 6-8
PRIMARY KEY 6-8
privileges 2-20
references column 2-15, 2-18, 6-8
REFERENTIAL INTEGRITY 6-8
UNIQUE 6-8
CONTROL QUERY DEFAULT statement
attributes 10-32