NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-25
I
altering attributes A-15
alternate access path E-17
available space F-20
block length F-17
catalog description of I-10
column limit L-6
configuration file for parallel
loading P-5
CREATE INDEX statement C-133
date-caused program
recompilation F-20
dependencies on base table C-139
displaying physical characteristics F-9
DROP statement D-62
dropping P-31
expiration date, setting N-4
file statistics F-22
for catalog tables C-7
keytags I-9
levels and ICOMPRESS I-1
limit per table L-8
loading data into L-17
loading using subsorts C-136, C-141
open state F-19
parallel loading of partitions C-136, P-5
partitioned P-19
partitions
adding A-18
null values P-17
physical file attributes C-102
size limit L-8
sorting and null values C-140
specifying file attributes of an C-137
unique and nonunique I-9
unpartitioned P-19
versions V-7
Index keys I-9
INDEXES catalog table I-10
INDEXES option, DUP command D-72
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-13
INDICATOR parameter I-11
Indicator variable H-6, I-11, P-13
INFO DEFINE command I-11
Initial object
DISPLAY USE OF command D-53
type D-53
INITIALIZE SQL command I-12
Initializing
columns A-31
, D-7
SQL I-12
Inner joins J-1, J-2
Inner query S-81, S-82
Inoperable plan P-21
Input host variables D-40
INSERT operations, buffered C-77
INSERT statement
access options I-15
and ORDER BY S-23
and scale S-47
ANYWHERE clause I-16
APPEND clause I-16
description of I-14
exceptions S-68
INTO clause I-15
RETURNING clause I-15
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