SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-5
C
scope of 3-11, 3-24
static and dynamic forms 3-11
syntax diagram of 3-11
Cluster sampling 7-11
Clustering key
description of 6-60
limits C-2
NONDROPPABLE PRIMARY KEY
specification 2-114
STORE BY clause 7-23
STORE BY clause, CREATE
TABLE 2-118
system-defined SYSKEY 6-63
COALESCE 8-27
COALESCE Function 8-27
CODE_VALUE function, syntax diagram
of 8-30
Collations
description of 6-6
SQL/MP considerations 1-33
COLS metadata table 10-15
Columns
column reference 6-7
default values 6-8
qualified name 6-7
COL_PRIVILEGES metadata table 10-20
Comment (--), examples of 1-4
Comments, host language 3-38
COMMIT WORK statement
C examples of 2-58
COBOL examples of 2-59
constraints check 2-57
MXCI examples of 2-57
syntax diagram of 2-57
Comparable data types 2-259, 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-259, 6-17
COMPILERCONTROLS function
examples of 8-32
syntax diagram of 8-31
Compound statements
BEGIN...END statement 3-14
IF statement 3-61
SET (assignment) statement 3-76
CONCAT function
examples of 8-35
syntax diagram of 8-34
Concatenation operator (||)
description of 8-34
examples of 8-25, 8-35
Concurrency
DDL_LOCKS metadata table 10-21
DELETE statement 2-165, 2-168
description of 1-16
import utility 5-28
INSERT statement 2-256, 2-258
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS default 10-57
MODIFY utility 2-294
MXCI sessions 4-48
NUMBER_OF_USERS default 10-71
SELECT statement 2-345, 2-347
SET TRANSACTION statement 2-376,
2-379
UPDATE statement 2-389, 2-391
VERIFY utility 5-81
Considerations 2-50
Considerations for DATEADD 8-45
Considerations for GRANT CREATE
CATALOG 2-245
Considerations for GRANT CREATE
SCHEMA 2-246
Considerations for GRANT
SECURITY_ADMIN 2-249
Considerations for REVOKE CREATE
CATALOG 2-320