NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-34
Examples—SET DEFINE
For example, if you use SET DEFINE to set attribute values for class TAPE and
enter the following command, the working set provides values for all attributes
except FILEID:
ADD DEFINE =T, CLASS TAPE, FILEID BACKUP
•
Attributes are set in the order they are specified. Because the CLASS attribute erases
the working set, you should set the CLASS attribute first, then set values for the
other attributes. When you include CLASS in a SET DEFINE command, you
establish a new working attribute set in which each attribute has its initial setting.
•
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.
•
If an error occurs on SET DEFINE, the working attribute set is unchanged.
•
An attribute value does not change until you reset it with the RESET DEFINE
command or another SET DEFINE command.
•
SET DEFINE checks that the value you enter is valid for the attribute you specify
and that the attribute is valid for the current class. Attribute consistency is not
checked until you issue an ADD DEFINE, ALTER DEFINE, or SHOW command.
•
It may be helpful to use the SHOW DEFINE command to display the current
working attribute set before you use a SET DEFINE command.
Examples—SET DEFINE
•
In the following example, SET DEFINE establishes a working attribute set for
CLASS CATALOG. The ADD DEFINE does not specify any attributes or attribute
values, so the working attribute set is associated with the DEFINE. In this case, the
=CAT DEFINE is mapped to subvolume \SYS1.$VOL1.PERSNL:
SET DEFINE CLASS CATALOG, SUBVOL \SYS1.$VOL1.PERSNL;
ADD DEFINE =CAT;
SET DEFMODE Command
SET DEFMODE is an SQLCI command that enables or disables the use of DEFINEs in
the current SQLCI session. (SET DEFMODE is similar to the TACL command SET
DEFMODE.)
ON
enables the use of DEFINEs. If DEFMODE is ON, you can execute commands that
contain DEFINE names and you can create, modify, or delete DEFINEs, display
information about DEFINES, and propagate existing DEFINEs to any processes you
start from the SQLCI session.
SET DEFMODE { ON } ;
{ OFF }