SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-4
C
syntax diagram of 4-8
CEILING function
examples of 8-22
syntax diagram of 8-22
CHAR data type 6-23
CHAR function
examples of 8-23
syntax diagram of 8-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-78
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 8-2
ASCII 8-11
CHAR 8-23
CHAR_LENGTH 8-24
CODE_VALUE 8-27
CONCAT 8-34
INSERT 8-84
LCASE 8-87
LEFT 8-88
LOCATE 8-91
LOWER 8-94
LPAD 8-99
LTRIM 8-102
OCTET_LENGTH 8-126
POSITION 8-131
REPEAT 8-145
REPLACE 8-146
RIGHT 8-147
RPAD 8-150
RTRIM 8-152
SESSION_USER 8-168
SPACE 8-170
SUBSTRING 8-174
TRANSLATE 8-181
TRIM 8-192
UCASE 8-193
UPPER 8-201
UPSHIFT 8-202
Character string literals 6-64
Character value expression
examples of 6-42
syntax diagram of 6-41
CHAR_LENGTH function
examples of 8-25
OCTET_LENGTH similarity to 8-24
syntax diagram of 8-24
CHECK constraint 6-9
CK_COL_USAGE metadata table 10-15
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 9-5
CREATE INDEX use of 9-5
purpose of 9-5
syntax diagram of 9-5
CLOSE statement
C examples of 3-12
COBOL examples of 3-13
effect on locks 3-12