SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-12
Considerations—ALTER DEFINE
you specify other attributes, the values you specified for the previous attributes are
erased. For more information about DEFINE attributes, see DEFINEs on
page D-27.
RESET reset-list
restores the value of each attribute listed in reset-list to its initial value.
You cannot reset a required attribute, so you cannot use this clause with CLASS
MAP and CLASS CATALOG DEFINEs.
Considerations—ALTER DEFINE

When you end an SQLCI session, DEFINEs that you inherited from another
process (such as TACL) and modified within SQLCI revert to the values they had
when you started SQLCI. Changes you make to inherited attributes from SQLCI
apply only within SQLCI.

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 a subvolume name, the name is
expanded immediately using 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.
Example—ALTER DEFINE
This 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;