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

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-17
J
INTERVAL data
inserting into SQL/MP columns 6-69
selecting from SQL/MP tables 6-30
Interval data type
description of 6-28
examples of literals 6-71
Interval literals
description of 6-67
examples of 6-71
Interval value expression
examples of 6-45
syntax diagram of 6-43
INVOKE command
examples of 4-33
syntax diagram of 4-33
INVOKE directive
examples of 3-66
syntax diagram of 3-63
whether preprocessor preserves or
overrides 3-29, 3-65
ISO standards E-2
ISO88591 character set 6-3
Isolation levels
READ COMMITTED 1-22
READ UNCOMMITTED 1-21
REPEATABLE READ 1-22
SERIALIZABLE 1-8, 1-10, 1-22
ISOLATION_LEVEL default 10-45
IUD_NONAUDITED_INDEX_MAINT
default 10-48
J
Java data types 2-61
Join
CONTROL QUERY SHAPE
statement 2-38
CROSS 2-183
INDEXJOIN 2-38
JOIN ON 2-183
join predicate 2-200
Join (continued)
LEFT 2-183
limits 2-192, C-1
NATURAL 2-183
NATURAL LEFT 2-183
NATURAL RIGHT 2-183
optional specifications 2-182
RIGHT 2-184
types 2-182
JOIN ON join, description of 2-183
JOIN_ORDER_BY_USER default 10-56
JULIANTIMESTAMP function
examples of 9-67
syntax diagram of 9-67
K
KANJI character set 6-3
Keys
clustering 6-56
first (partition) 6-57
index 6-58
primary 6-59
SYSKEY 6-59
Key-sequenced table 1-31
KEY_COL_USAGE metadata table 10-18
KSC5601 character set 6-3
L
LARGINT data type 6-32
LASTNOTNULL function
examples of 9-68
syntax diagram of 9-68
LCASE function
examples of 9-69
syntax diagram of 9-69
LEFT function
examples of 9-70
syntax diagram of 9-70
LEFT join, description of 2-183