SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-6
C
Character strings (continued)
literals S-80
matching pattern L-2
Character values, display format of A-61
CHARACTERISTICS in CPRULES
table C-131
CHARACTERSET
in COLUMNS table C-47
in CPRULES table C-131
CHAR_LENGTH function C-20
CHECK clause
CHECKMODE, in PROGRAMS
table P-32
CREATE CONSTRAINT
statement C-139
CREATE VIEW statement C-168
CHECKMODE, in PROGRAMS table P-32
Clauses
AS A-60
COLLATE C-29
CONCAT C-63
DEFAULT D-26
DISTINCT D-57
IF/THEN/ELSE I-1
PARTITION P-16
CLEANUP command
and dependent programs C-23
and shadow labels C-22
description of C-21
CLEAR clause, COMMENT
statement C-48
CLEAR option
LOG command L-52
OUT command O-7
CLEARONPURGE
in FILES table F-27
in PROGRAMS table P-31
CLEARONPURGE file attribute
ALTER CATALOG statement A-8
ALTER INDEX statement A-15
ALTER PROGRAM statement A-27
CLEARONPURGE file attribute (continued)
description of C-26
SECURE command S-8
CLOSE statement
and locking L-51
description of C-26
Closing
cursors C-27
FREE RESOURCES statement F-30
CLUSTERING KEY clause, CREATE
TABLE statement C-158
Clustering keys
and EXECUTE RETURNING E-9
description of C-28
length limit L-6
CNVSRC file C-97
COBOL language
and embedded SQL E-2
invoking record definition I-26
COLCLASS, in COLUMNS table C-46
COLCOUNT
in INDEXES table I-10
in TABLES table T-2
COLLATE clause
associating with a column D-3
CREATE INDEX statement C-144
description of C-29
effect on data-type specification D-3
Collations
ALTER COLLATION statement A-10
associating with a column D-3
catalog description of T-2
CREATE COLLATION
statement C-137
definitions C-30
description of C-43
DROP statement D-64
duplicating D-75
in expressions C-14
renaming A-10