SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-33
Considerations—SET DEFINE
attr value
is the name and value of a DEFINE attribute to add to the working attribute set. For
information about DEFINE attributes, see DEFINEs on page D-27.
Considerations—SET DEFINE

The working attribute set consists of values for the attributes of the current class.
Only one class of attributes can be in the working set at one time.
For example, if you use SET DEFINE to set attribute values for class TAPE and
enter this 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.

Use the SHOW DEFINE command to display the current working attribute set
before you use a SET DEFINE command.
Example—SET DEFINE
This 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;