SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-17
J
INSERT statement (continued)
limits 2-172, C-1
lock modes 2-172
MXCI examples of 2-176
ORDER BY clause 2-171
query expression within 2-170
syntax diagram of 2-168
target column list 2-170
using host variables 2-174
VALUES specification within 2-174
INSERT statement (embedded)
C examples of 2-178
COBOL examples of 2-178
Insertable views 2-114
INSERT_VSBB default 10-66
INTEGER data type 6-33
INTERACTIVE_ACCESS default 10-70
INTERVAL data
inserting into SQL/MP columns 6-70
selecting from SQL/MP tables 6-31
Interval data type
description of 6-29
examples of literals 6-72
Interval literals
description of 6-68
examples of 6-72
Interval value expression
examples of 6-46
syntax diagram of 6-44
INVOKE command
examples of 4-35
syntax diagram of 4-35
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-22
READ UNCOMMITTED 1-21
REPEATABLE READ 1-22
SERIALIZABLE 1-8, 1-10, 1-22
ISOLATION_LEVEL default 10-47
IUD_NONAUDITED_INDEX_MAINT
default 10-51
J
Java data types 2-65
Join
CONTROL QUERY SHAPE
statement 2-42
CROSS 2-206
INDEXJOIN 2-42
JOIN ON 2-206
join predicate 2-223
LEFT 2-206
limits 2-215, C-1
NATURAL 2-206
NATURAL LEFT 2-206
NATURAL RIGHT 2-206
optional specifications 2-205
RIGHT 2-207
types 2-205
JOIN ON join, description of 2-206
JOIN_ORDER_BY_USER default 10-60
JULIANTIMESTAMP function
examples of 9-71
syntax diagram of 9-71
K
KANJI character set 6-4
Keys
clustering 6-57
first (partition) 6-58
index 6-59
primary 6-60