SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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-32
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-49
COBOL examples of 2-50
constraints check 2-48
MXCI examples of 2-48
syntax diagram of 2-48
Comparable data types 2-216, 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-216, 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-21
DELETE statement 2-150, 2-151
description of 1-16
import utility 5-45
INSERT statement 2-213, 2-214
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS default 10-57
MODIFY utility 5-91
MXCI sessions 4-48
NUMBER_OF_USERS default 10-70
SELECT statement 2-257, 2-259
SET TRANSACTION statement 2-288,
2-291
UPDATE statement 2-301, 2-303
VERIFY utility 5-133
Considerations 2-42
Considerations for GIVE SCHEMA 5-29
Considerations for GRANT CREATE
CATALOG 2-201
Considerations for GRANT CREATE
SCHEMA 2-202
Considerations for GRANT
SECURITY_ADMIN 2-206