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-18
J
inserting into SQL/MP columns 6-73
selecting from SQL/MP tables 6-33
Interval data type
description of 6-31
examples of literals 6-75
Interval literals
description of 6-71
examples of 6-75
Interval value expression
examples of 6-49
syntax diagram of 6-47
INVOKE command
examples of 4-46
syntax diagram of 4-46
INVOKE directive
examples of 3-67
syntax diagram of 3-64
whether preprocessor preserves or
overrides 3-30, 3-66
ISO standards E-2
ISO88591 character set 6-4
Isolation levels
READ COMMITTED 1-24
READ UNCOMMITTED 1-23
REPEATABLE READ 1-24
SERIALIZABLE 1-9, 1-11, 1-24
ISOLATION_LEVEL default 10-56
IUD_NONAUDITED_INDEX_MAINT
default 10-60
J
Java data types 2-90
Join
CONTROL QUERY SHAPE
statement 2-66
CROSS 2-339
INDEXJOIN 2-66
JOIN ON 2-339
join predicate 2-356
LEFT 2-339
limits 2-348, C-1
NATURAL 2-339
NATURAL LEFT 2-339
NATURAL RIGHT 2-339
optional specifications 2-338
RIGHT 2-340
types 2-338
JOIN ON join, description of 2-339
JOIN_ORDER_BY_USER default 10-69
JULIANTIMESTAMP function
examples of 8-85
syntax diagram of 8-85
K
KANJI character set 6-4
Keys
clustering 6-60
first (partition) 6-61
index 6-62
primary 6-63
SYSKEY 6-63
Key-sequenced table 1-33
KEY_COL_USAGE metadata table 10-22
KSC5601 character set 6-4
L
LARGINT data type 6-36
LASTNOTNULL function
examples of 8-86
syntax diagram of 8-86
LCASE function
examples of 8-87
syntax diagram of 8-87
LEFT function
examples of 8-88
syntax diagram of 8-88
LEFT join, description of 2-339
LIKE predicate
CREATE TABLE 2-124