SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-4
C
CEILING function (continued)
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-46
Character sets
description of 6-4
ISO88591 6-4
KANJI 6-4
KSC5601 6-4
setting default 6-64, 6-65, 6-66, 10-74
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-31
INSERT 9-72
LCASE 9-75
LEFT 9-76
LOCATE 9-77
LOWER 9-80
LPAD 9-85
LTRIM 9-88
OCTET_LENGTH 9-109
POSITION 9-113
REPEAT 9-127
REPLACE 9-128
Character string functions (continued)
RIGHT 9-129
RPAD 9-132
RTRIM 9-134
SESSION_USER 9-150
SPACE 9-152
SUBSTRING 9-156
TRANSLATE 9-163
TRIM 9-165
UCASE 9-166
UPPER 9-174
UPSHIFT 9-175
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-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