NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-14
RESET DEFINE Command
RESET DEFINE Command
RESET DEFINE is an SQLCI command that restores one or more DEFINE attributes in
the working attribute set to their initial settings. (RESET DEFINE is similar to the
TACL command ADD DEFINE.)
attr
is a DEFINE attribute whose value is to be reset to its initial value. (See DEFINEs
on page D-26 for a list of DEFINE attributes.)
*
resets the DEFINE class to MAP and establishes a working attribute set that consists
of the FILE attribute set to its initial value (which is no value).
Considerations—RESET DEFINE
•
See SET DEFINE Command on page S-33 for a description of the working attribute
set.
•
If an error occurs when you enter a RESET DEFINE command, the command does
not change the working attribute set.
•
Attributes are reset in the order you specify them.
•
When you reset the CLASS attribute, you set the DEFINE class to MAP and
establish a working attribute set consisting of the FILE attribute (set to its initial
value).
•
If you reset an attribute that does not belong to the current class, an error message
appears.
Examples—RESET DEFINE
•
The following example shows the way RESET DEFINE changes the working
attribute set. Initially, the working attribute set contains attributes for CLASS
CATALOG. RESET DEFINE resets the SUBVOL attribute value. Because the
RESET DEFINE { attr [ , attr ] ... } ;
{ * }