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

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-4
C
examples of 4-8
path name within 4-8
syntax diagram of 4-8
CEILING function
examples of 9-22
syntax diagram of 9-22
CHAR data type 6-23
CHAR function
examples of 9-23
syntax diagram of 9-23
CHAR VARYING data type 6-23
Character set
default attribute 10-49
Character sets
description of 6-4
ISO88591 6-4
KANJI 6-4
KSC5601 6-4
setting default 6-64, 6-65, 6-66, 10-77
support standards E-7
UCS2 6-4
Character string data types
CHAR and VARCHAR,
differences 6-23
examples of literals 6-67
maximum storage lengths 6-24
Character string functions
summary of 9-2
ASCII 9-11
CHAR 9-23
CHAR_LENGTH 9-24
CODE_VALUE 9-27
CONCAT 9-34
INSERT 9-79
LCASE 9-82
LEFT 9-83
LOCATE 9-86
LOWER 9-89
LPAD 9-94
LTRIM 9-97
OCTET_LENGTH 9-121
POSITION 9-126
REPEAT 9-140
REPLACE 9-141
RIGHT 9-142
RPAD 9-145
RTRIM 9-147
SESSION_USER 9-163
SPACE 9-165
SUBSTRING 9-169
TRANSLATE 9-176
TRIM 9-187
UCASE 9-188
UPPER 9-196
UPSHIFT 9-197
Character string literals 6-64
Character value expression
examples of 6-42
syntax diagram of 6-41
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-14
CK_TBL_USAGE metadata table 10-15
Clauses
DEFAULT 7-2
PARTITION 7-6
SAMPLE 7-9
SEQUENCE BY 7-19
STORE BY 7-23
TRANSPOSE 7-26
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