SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-5
C
COBOL examples of 3-13
effect on locks 3-12
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-102
STORE BY clause 7-23
STORE BY clause, CREATE
TABLE 2-106
system-defined SYSKEY 6-63
COALESCE 9-27
COALESCE Function 9-27
CODE_VALUE function, syntax diagram
of 9-30
Collations
description of 6-6
SQL/MP considerations 1-33
COLS metadata table 10-16
Columns
column reference 6-7
default values 6-8
qualified name 6-7
COL_PRIVILEGES metadata table 10-21
Comment (--), examples of 1-5
Comments, host language 3-38
COMMIT WORK statement
C examples of 2-50
COBOL examples of 2-51
constraints check 2-49
MXCI examples of 2-49
syntax diagram of 2-49
Comparable data types 2-224, 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-224, 6-17
COMPILERCONTROLS function
examples of 9-32
syntax diagram of 9-31
Compound statements
BEGIN...END statement 3-14
IF statement 3-61
SET (assignment) statement 3-76
CONCAT function
examples of 9-35
syntax diagram of 9-34
Concatenation operator (||)
description of 9-34
examples of 9-25, 9-35
Concurrency
DDL_LOCKS metadata table 10-22
DELETE statement 2-153, 2-156
description of 1-17
import utility 5-52
INSERT statement 2-221, 2-223
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS default 10-58
MODIFY utility 5-98
MXCI sessions 4-48
NUMBER_OF_USERS default 10-73
SELECT statement 2-270, 2-272
SET TRANSACTION statement 2-301,
2-304
UPDATE statement 2-314, 2-316
VERIFY utility 5-144
Considerations 2-43
Considerations for DATEADD 9-45
Considerations for GIVE SCHEMA 5-35
Considerations for GRANT CREATE
CATALOG 2-209
Considerations for GRANT CREATE
SCHEMA 2-210