NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-12
Examples—ALTER DEFINE
•
ALTER DEFINE affects only existing DEFINEs, not the working attribute set. (SET
DEFINE modifies the working attribute set.)
•
Attributes are altered in the order in which they are specified.
•
If the value of an attribute is a Guardian name or subvolume name, the name is
expanded immediately using the current default node, volume, and subvolume.
•
You cannot alter an attribute unless it is valid for the class of the DEFINE. For
example, you cannot alter the FILE attribute if the CLASS of the DEFINE is
CATALOG.
•
The DEFMODE setting does not affect your ability to alter a DEFINE.
Examples—ALTER DEFINE
•
The following example alters the FILE attribute for a set of DEFINEs:
ALTER DEFINE =CUSTOMER_TABLE, FILE
\SYS1.$TEST.SALES.CUSTOMER;
ALTER DEFINE =ORDERS_TABLE, FILE \SYS1.$TEST.SALES.ORDERS;
ALTER DEFINE =ODETAIL_TABLE, FILE \SYS1.$TEST.SALES.ODETAIL;
ALTER DEFINE =PARTS_TABLE, FILE \SYS1.$TEST.SALES.PARTS;
ALTER INDEX Statement
ALTER INDEX is a DDL statement that renames, changes security, or changes file
attributes for an entire index; drops or adds an index partition; or changes file attributes
for an index partition.
The ALTER INDEX statement also supports several types of move and split operations,
including:
•
Moving an entire index partition to another disk volume
•
Merging an index partition into another existing partition
•
Splitting an index partition and moving part into a newly created partition