SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-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-50
Character sets
description of 6-4
ISO88591 6-4
KANJI 6-4
KSC5601 6-4
setting default 6-64, 6-65, 6-66, 10-80
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-84
LCASE 9-87
LEFT 9-88
LOCATE 9-91
LOWER 9-94
LPAD 9-99
LTRIM 9-102
OCTET_LENGTH 9-126
POSITION 9-131
REPEAT 9-145
REPLACE 9-146
RIGHT 9-147
RPAD 9-150
RTRIM 9-152
SESSION_USER 9-168
SPACE 9-170
SUBSTRING 9-174
TRANSLATE 9-181
TRIM 9-192
UCASE 9-193
UPPER 9-201
UPSHIFT 9-202
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-15
CK_TBL_USAGE metadata table 10-16
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