SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-2
A
ALTER INDEX statement
ADD PARTITION clause A-18
ALLOCATE clause A-18
description of A-13
DROP PARTITION clause A-15
examples of A-26
file security attributes A-15
FIRST KEY clause A-18
Format 2 enabling A-25
MAXEXTENTS clause A-18
MOVE clause A-16
MOVE options A-16
RENAME clause A-15
RESETBROKEN clause A-18
SECURE file attribute A-15
WITH SHARED ACCESS clause A-17
ALTER PROGRAM statement
description of A-27
OWNER file attribute A-27
RENAME clause A-27
SECURE file attribute A-27
ALTER statements
and GRANT S-68
catalog A-8
collation A-10
concurrent DML operations C-65
index A-13
program A-27
table A-29
view A-50
ALTER TABLE ADD CONSTRAINT
statement S-70
ALTER TABLE DROP CONSTRAINT
statement S-70
ALTER TABLE statement
ADD COLUMN clause A-33
ADD PARTITION clause A-36
DEFAULT clause A-33, D-26
description of A-29
DROP PARTITION clause A-34
ALTER TABLE statement (continued)
file attributes A-32
FIRST KEY clause A-37
Format 2 enabling A-45
HEADING clause H-1
MOVE clause A-34
OWNER file attribute A-32
PARTITION ARRAY attribute A-33
RENAME clause A-32
REUSE PARTITION clause A-37
SECURE file attribute A-32
SIMILARITY CHECK clause A-32
splitting A-40
ALTER VIEW statement
description of A-50
HEADING clause A-50, H-1
OWNER file attribute A-50
RENAME clause A-50
SECURE file attribute A-50
Altered plan P-22
Alternate access path E-16
Alternate message file Z-18
AND operator S-5
ANSI SQL, compatibility with S-67
ANY clause, in quantified predicate Q-6
ANYWHERE clause, INSERT
statement I-16
APPEND clause, INSERT statement I-16
APPEND command
compared to COPY A-55
compared to LOAD A-55
description of A-52
APPENDCANCEL command A-56
APPENDRESTART command A-58
Approximate numeric data types D-5, N-12
Arithmetic operators E-25
AS clause
CREATE VIEW statement C-167
description of A-60
INVOKE directive I-25