SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-4
C
CEILING function (continued)
syntax diagram of 9-22
CHAR data type 6-21, 6-22
CHAR function
examples of 9-23
syntax diagram of 9-23
CHAR VARYING data type 6-21
Character sets
description of 6-4
ISO88591 6-4
KANJI 6-4
KSC5601 6-4
setting default 6-61, 6-62, 6-63, 10-69
support standards E-7
UCS2 6-4
Character string data types
CHAR and VARCHAR,
differences 6-22
examples of literals 6-64
maximum storage lengths 6-22
Character string functions
summary of 9-2
ASCII 9-11
CHAR 9-23
CHAR_LENGTH 9-24
CODE_VALUE 9-27
CONCAT 9-31
INSERT 9-70
LCASE 9-73
LEFT 9-74
LOCATE 9-75
LOWER 9-78
LPAD 9-83
LTRIM 9-84
OCTET_LENGTH 9-105
POSITION 9-109
REPEAT 9-121
REPLACE 9-122
RIGHT 9-123
RPAD 9-126
Character string functions (continued)
RTRIM 9-127
SESSION_USER 9-143
SPACE 9-145
SUBSTRING 9-149
TRANSLATE 9-156
TRIM 9-158
UCASE 9-159
UPPER 9-167
UPSHIFT 9-168
Character string literals 6-61
Character value expression
examples of 6-39
syntax diagram of 6-38
CHAR_LENGTH function
examples of 9-25
OCTET_LENGTH similarity to 9-24
syntax diagram of 9-24
CHECK constraint 6-9
CK_COL_USAGE metadata table 10-13
CK_TBL_USAGE metadata table 10-13
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