SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-18
J
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-22
READ UNCOMMITTED 1-21
REPEATABLE READ 1-22
SERIALIZABLE 1-8, 1-10, 1-22
ISOLATION_LEVEL default 10-53
IUD_NONAUDITED_INDEX_MAINT
default 10-57
J
Java data types 2-63
Join
CONTROL QUERY SHAPE
statement 2-40
CROSS 2-207
INDEXJOIN 2-40
JOIN ON 2-207
join predicate 2-224
LEFT 2-207
limits 2-216, C-1
NATURAL 2-207
NATURAL LEFT 2-207
NATURAL RIGHT 2-207
optional specifications 2-206
RIGHT 2-208
types 2-206
JOIN ON join, description of 2-207
JOIN_ORDER_BY_USER default 10-66
JULIANTIMESTAMP function
examples of 9-73
JULIANTIMESTAMP function (continued)
syntax diagram of 9-73
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-31
KEY_COL_USAGE metadata table 10-20
KSC5601 character set 6-4
L
LARGINT data type 6-36
LASTNOTNULL function
examples of 9-74
syntax diagram of 9-74
LCASE function
examples of 9-75
syntax diagram of 9-75
LEFT function
examples of 9-76
syntax diagram of 9-76
LEFT join, description of 2-207
LIKE predicate
CREATE TABLE 2-92
escape character within 6-98
examples of 6-99
NOT within 6-97
syntax diagram of 6-97
wild-card characters within 6-98
Limits
constraints C-1
DROP SCHEMA C-1
extents C-1
IN predicate 6-95, C-1