SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-4
C
CHAR function (continued)
syntax diagram of 9-25
CHAR VARYING data type 6-20
Character sets
description of 6-3
ISO88591 6-3
KANJI 6-3
KSC5601 6-3
setting default 6-62, 6-63, 6-64, 10-62
support standards E-7
UCS2 6-3
Character string data types
CHAR and VARCHAR,
differences 6-21
examples of literals 6-65
maximum storage lengths 6-22
Character string functions
summary of 9-2
ASCII 9-12
CHAR 9-25
CHAR_LENGTH 9-26
CODE_VALUE 9-29
CONCAT 9-30
INSERT 9-65
LCASE 9-68
LEFT 9-69
LOCATE 9-70
LOWER 9-74
LPAD 9-79
LTRIM 9-80
OCTET_LENGTH 9-101
POSITION 9-105
REPEAT 9-119
REPLACE 9-120
RIGHT 9-121
RPAD 9-124
RTRIM 9-125
SESSION_USER 9-141
SPACE 9-145
Character string functions (continued)
SUBSTRING 9-150
TRANSLATE 9-158
TRIM 9-160
UCASE 9-161
UPPER 9-169
UPSHIFT 9-170
Character string literals 6-62
Character value expression
examples of 6-40
syntax diagram of 6-39
CHAR_LENGTH function
examples of 9-27
OCTET_LENGTH similarity to 9-26
syntax diagram of 9-26
CHECK constraint 6-8
CK_COL_USAGE metadata table 10-12
CK_TBL_USAGE metadata table 10-12
Clauses
DEFAULT 7-2
PARTITION 7-5
SAMPLE 7-8
SEQUENCE BY 7-18
STORE BY 7-22
TRANSPOSE 7-25
CLEARONPURGE file attribute
ALTER INDEX use of 8-5
CREATE INDEX use of 8-5
purpose of 8-5
syntax diagram of 8-5
CLOSE statement
C examples of 3-12
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-10
Clustering key
description of 6-58