SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-4
C
CEILING function
examples of 9-22
syntax diagram of 9-22
CHAR data type 6-20, 6-21
CHAR function
examples of 9-23
syntax diagram of 9-23
CHAR VARYING data type 6-20
Character sets
description of 6-3
ISO88591 6-3
KANJI 6-3
KSC5601 6-3
setting default 6-60, 6-61, 6-62, 10-64
support standards E-7
UCS2 6-3
Character string data types
CHAR and VARCHAR,
differences 6-21
examples of literals 6-63
maximum storage lengths 6-21
Character string functions
summary of 9-2
ASCII 9-11
CHAR 9-23
CHAR_LENGTH 9-24
CODE_VALUE 9-27
CONCAT 9-28
INSERT 9-66
LCASE 9-69
LEFT 9-70
LOCATE 9-71
LOWER 9-74
LPAD 9-79
LTRIM 9-80
OCTET_LENGTH 9-101
POSITION 9-105
REPEAT 9-117
REPLACE 9-118
RIGHT 9-119
Character string functions (continued)
RPAD 9-122
RTRIM 9-123
SESSION_USER 9-139
SPACE 9-141
SUBSTRING 9-145
TRANSLATE 9-152
TRIM 9-154
UCASE 9-155
UPPER 9-163
UPSHIFT 9-164
Character string literals 6-60
Character value expression
examples of 6-38
syntax diagram of 6-37
CHAR_LENGTH function
examples of 9-25
OCTET_LENGTH similarity to 9-24
syntax diagram of 9-24
CHECK constraint 6-8
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