SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-16
J
INSERT statement (continued)
MXCI examples of 2-157
ORDER BY clause 2-152
query expression within 2-151
syntax diagram of 2-149
target column list 2-151
using host variables 2-155
VALUES specification within 2-155
INSERT statement (embedded)
C examples of 2-159
COBOL examples of 2-159
Insertable views 2-109
INSERT_VSBB default 10-59
INTEGER data type 6-34
INTERACTIVE_ACCESS default 10-62
INTERVAL data
inserting into SQL/MP columns 6-71
selecting from SQL/MP tables 6-32
Interval data type
description of 6-30
examples of literals 6-73
Interval literals
description of 6-69
examples of 6-73
Interval value expression
examples of 6-47
syntax diagram of 6-45
INVOKE command
examples of 4-33
syntax diagram of 4-33
INVOKE directive
examples of 3-68
syntax diagram of 3-65
whether preprocessor preserves or
overrides 3-29, 3-67
ISO standards E-2
ISO88591 character set 6-3
Isolation levels
READ COMMITTED 1-20
READ UNCOMMITTED 1-20
Isolation levels (continued)
REPEATABLE READ 1-21
SERIALIZABLE 1-21
ISOLATION_LEVEL default 10-44
Iterator
DELETE statement use of 2-113
UPDATE statement use of 2-236
IUD_NONAUDITED_INDEX_MAINT
default 10-47
J
Java data types 2-63
Join
CONTROL QUERY SHAPE
statement 2-40
CROSS 2-187
INDEXJOIN 2-40
JOIN ON 2-187
join predicate 2-204
LEFT 2-187
limits 2-196
NATURAL 2-187
NATURAL LEFT 2-187
NATURAL RIGHT 2-187
optional specifications 2-186
RIGHT 2-188
types 2-186
JOIN ON join, description of 2-187
JOIN_ORDER_BY_USER default 10-55
JULIANTIMESTAMP function
examples of 9-66
syntax diagram of 9-66
K
KANJI character set 6-3
Keys
clustering 6-58
first (partition) 6-59
index 6-60