SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-24
I
HEADINGTEXT in COLUMNS table C-47
HELP command H-2
HELP TEXT statement H-4
Help text, deleting H-4
Hidden text C-51
HISTORY command H-5
Host and SQL communication H-6
Host identifiers H-5
Host object SQL version (HOSV) V-8
Host programming language
compiler versions V-8
description of E-2, H-5
Host programs H-6
Host variables
declaration B-2
description of H-6
substituting values in a query H-6
TYPE AS clause H-6
HOSV (host object SQL version) V-8
I
ICOMPRESS file attribute
description of I-1
displaying F-17
ICOMPRESS, in FILES table F-27
Identifiers, SQL S-59
IDs S-12
IF/THEN/ELSE clause
description of I-1
report writer option R-10
IN predicate I-3, L-8
INCLUDE SQLDA directive
collation buffer I-5
description of I-4
names buffer I-5
INCLUDE SQLSA directive I-6
INCLUDE STRUCTURES directive I-7
Index
address of EOF F-19
ALTER INDEX statement A-13
Index (continued)
altering attributes A-15
alternate access path E-16
available space F-19
block length F-17
catalog description of I-10
column limit L-6
configuration file for parallel
loading P-5
CREATE INDEX statement C-142
data, loading into L-18
date-caused program
recompilation F-19
dependencies on base table C-148
displaying physical characteristics F-9
DROP statement D-64
dropping P-33
expiration date, setting N-5
file statistics F-22
for catalog tables C-9
keytags I-9
levels and ICOMPRESS I-1
limit per table L-8
open state F-19
partitioned P-19
physical file attributes C-107
size limit L-8
sorting and null values C-149
specifying file attributes of an C-146
unique and nonunique I-9
unpartitioned P-19
using subsorts C-145
versions V-7
Index keys I-9
Index loading
partitions in parallel C-145, P-5
using subsorts C-151
Index partitions
adding A-18
null values P-17