NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-26
J
Inserting null values I-17
Inserting rows I-14
Inserts, sequential C-78, C-82
INTEGER data syntax D-5
Integrity constraint, creating C-131
INTERACTIVE ACCESS option,
CONTROL QUERY directive C-71
Interactive interface
See SQLCI
INTERVAL
data syntax D-7
data type I-19
literals I-22
Interval expressions E-23
INTERVAL values
in host variables H-6
LOAD command L-37
INTO clause
FETCH statement F-3
INSERT statement I-15
SELECT statement S-19
Invalid object V-3
Invalid plan P-22
Invalid program P-22, P-28
INVALIDATE clause, CREATE INDEX
statement C-136
Invalidation of programs P-28
INVOKE directive
and BIND NAMES option C-70
NULL STRUCTURE clause I-27
INVOKE directive and command I-24
IS NULL predicate N-6
ISLACK file attribute I-29
ISLACK option, LOAD command L-27
ISO 8859 character sets C-16
ISO character sets, ASCII A-64
ISO SQL, compatibility with S-67
Isolation Level S-70
IXINDE01 file C-7
IXPART01 catalog table, limits L-9
IXPART01 file C-7
IXPROG01 file C-7
IXTABL01 file C-7
IXUSAG01 file C-7
I/O (input/output)
serial or parallel writes S-32
verify disk writes V-1
J
JIS X0208 character set C-17
JOIN METHOD option, CONTROL
TABLE directive C-75
Join queries J-1
JOIN SEQUENCE option, CONTROL
TABLE directive C-76
Joins
controlling C-81
description of J-1
example of S-31
inner J-1, J-2
left outer J-1
SELECT specification S-20
Julian timestamp
and COMPUTE_TIMESTAMP C-57
formatting A-55
JULIANTIMESTAMP function J-4
Justification A-56, A-57, A-58, A-59, A-60,
A-61
K
Kanji character set C-17
KEY clause
CLUSTERING, CREATE TABLE
statement C-147
PRIMARY, CREATE TABLE
statement C-147
KEY option, LOAD command L-21
Key specifier, displaying F-18
Keys