NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-2
A
OWNER file attribute A-9
RENAME clause A-9
SECURE file attribute A-9
ALTER DEFINE command A-11
ALTER INDEX statement
ADD PARTITION clause A-18
description of A-12
examples of A-24
file attributes A-15
FIRST KEY clause A-18
SECURE file attribute A-15
ALTER PROGRAM statement
description of A-25
OWNER file attribute A-25
RENAME clause A-26
SECURE file attribute A-25
ALTER statements
and GRANT S-68
catalog A-7
collation A-9
concurrent DML operations C-61
index A-12
program A-25
table A-27
view A-45
ALTER TABLE ADD CONSTRAINT
statement S-69
ALTER TABLE DROP CONSTRAINT
statement S-69
ALTER TABLE statement
ADD COLUMN clause A-31
ADD PARTITION clause A-34
DEFAULT clause A-31, D-24
description of A-27
DROP PARTITION clause A-31
file attributes A-30
FIRST KEY clause A-34, A-35
HEADING clause H-1
MOVE clause A-32
OWNER file attribute A-30
PARTITION ARRAY attribute A-31
RENAME clause A-30
REUSE PARTITION clause A-34
SECURE file attribute A-30
SIMILARITY CHECK clause A-30
splitting A-37
ALTER VIEW statement
description of A-45
HEADING clause A-45, H-1
OWNER file attribute A-45
RENAME clause A-45
SECURE file attribute A-45
Altered plan P-22
Alternate access path E-17
Alternate collector R-3
Alternate indexes C-133
Alternate message file Z-16
AND operator S-5
ANSI SQL, compatibility with S-67
ANY clause, in quantified predicate Q-5
ANYWHERE clause, INSERT
statement I-16
APPEND clause, INSERT statement I-16
APPEND command
compared to COPY A-50
compared to LOAD A-50
description of A-47
APPENDCANCEL command A-51
APPENDRESTART command A-53
Approximate numeric data types D-5, N-13
Arithmetic operators E-22
AS clause
CREATE VIEW statement C-157
description of A-54
INVOKE directive I-25
report writer option R-12
AS DATE/TIME clause
description of A-62