SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
Index-1
Index
Numbers
255, user number G-7, S-12
A
A (alphanumeric) descriptor A-61
Abort transaction R-22
Access options
BROWSE A-1
concurrency summary A-3
DDL statements W-4
description of A-1
DML statements A-1
INSERT statement I-15
REPEATABLE A-1
STABLE A-1
UPDATE statement U-3
Access path
alternate E-16
controlling C-79, C-85, C-86
primary E-16
ACCESS PATH option
CONTROL TABLE directive C-79
controlling C-79, C-85
in EXPLAIN report E-16
Access type, in EXPLAIN report E-16
Ada language S-69
ADD COLUMN clause
See ALTER TABLE statement
ADD DEFINE command A-4
ADD PARTITION clause
ALTER INDEX statement A-18
ALTER TABLE statement A-36
Adding partitions
index A-18
, A-25
table A-36
Aggregate functions
AVG A-76
COUNT C-130
description of A-6
MAX M-1
MIN M-3
SUM S-89
Alias
assigning to column N-1
definition of A-6
ALL option, SAVE command S-2
ALLINDEXESHERE, in BASETABS
table B-1
ALLOCATE clause, ALTER INDEX
statement A-18
ALLOCATE file attribute A-7
Allocated extents F-19
Allocating disk space with EXTENT E-30
ALLOWERRORS option
COPY command C-116
DUP command D-72
LOAD command L-20
PURGE command P-34
PURGEDATA command P-37
SECURE command S-8
ALL, in quantified predicate Q-6
ALTER CATALOG statement
description of A-8
NOPURGEUNTIL attribute A-8
OWNER file attribute A-8
SECURE file attribute A-8
ALTER COLLATION statement
description of A-10
OWNER file attribute A-10
RENAME clause A-10
SECURE file attribute A-10
ALTER DEFINE command A-11