SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-18
J
INTEGER data type 6-35
INTERACTIVE_ACCESS default 10-81
INTERVAL data
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-10, 1-12, 1-24
ISOLATION_LEVEL default 10-57
IUD_NONAUDITED_INDEX_MAINT
default 10-61
J
Java data types 2-82
Join
CONTROL QUERY SHAPE
statement 2-58
CROSS 2-264
INDEXJOIN 2-58
JOIN ON 2-264
join predicate 2-281
LEFT 2-264
limits 2-273, C-1
NATURAL 2-264
NATURAL LEFT 2-264
NATURAL RIGHT 2-264
optional specifications 2-263
RIGHT 2-265
types 2-263
JOIN ON join, description of 2-264
JOIN_ORDER_BY_USER default 10-71
JULIANTIMESTAMP function
examples of 9-85
syntax diagram of 9-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-23
KSC5601 character set 6-4
L
LARGINT data type 6-36
LASTNOTNULL function
examples of 9-86
syntax diagram of 9-86
LCASE function
examples of 9-87
syntax diagram of 9-87
LEFT function
examples of 9-88
syntax diagram of 9-88