SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-25
I
INDEXES catalog table I-10
INDEXES option, DUP command D-74
INDEXLEVELS, in INDEXES table I-10
INDEXNAME
in INDEXES table I-10
in KEYS table K-1
INDICATOR clause
host variable H-6
parameter name P-12
INDICATOR parameter I-11
Indicator variable H-6, I-11, P-12
INFO DEFINE command I-12
Initial object
DISPLAY USE OF command D-56
type D-56
INITIALIZE SQL command I-13
Initializing columns A-33, D-7
Inner joins J-1, J-2
Inner query S-83, S-84
Inoperable plan P-22
Input host variables D-41
INSERT operations, buffered C-82
INSERT statement
access options I-15
and ORDER BY S-23
ANYWHERE clause I-16
APPEND clause I-16
description of I-14
exceptions S-68
INTO clause I-15
RETURNING clause I-15
scale of S-46
SYSKEY clause I-14
INSERTABLE, in VIEWS table V-10
Inserting
and check option I-17
and constraints I-17
compatible data types I-16
date-time values I-17
null values I-17
Inserting (continued)
rows I-14
Inserts, sequential C-83, C-87
INTEGER data syntax D-5
Integrity constraint, creating C-139
INTERACTIVE ACCESS option, CONTROL
QUERY directive C-75
Interactive interface
See SQLCI
INTERVAL
data syntax D-7
data type I-19
literals I-22
Interval expressions E-22
INTERVAL values
in host variables H-6
LOAD command L-38
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
INVALIDATE clause, CREATE INDEX
statement C-144
INVOKE directive
and BIND NAMES option C-74
and command I-25
NULL STRUCTURE clause I-27
IS NULL predicate N-6
ISLACK file attribute I-29
ISLACK option, LOAD command L-29
ISO
8859 character sets C-18
character sets, ASCII A-70
SQL, compatibility with S-67
Isolation Level S-70
IXINDE01 file C-9