NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-4
ADD DEFINE Command
ADD DEFINE Command
ADD DEFINE is an SQLCI command that creates DEFINEs in the current SQLCI
session. (ADD DEFINE is similar to the TACL command ADD DEFINE and the OSS
command add_define.)
define
is a name for the new DEFINE; the name cannot be the same as the name of an
existing DEFINE.
A DEFINE name must begin with an equal sign (=) followed by a letter and can
contain 2 to 24 characters, including alphanumeric characters, hyphens (-),
underscores (_), and circumflexes (^). Uppercase and lowercase characters are
considered equivalent in DEFINE names. Defines supplied by Tandem start with an
equal sign followed by an underscore character (=_).
The new DEFINE has the attributes and values of the working attribute set modified
by any attr value pairs you specify, unless you specify a LIKE clause. (The
working attribute set is a set of default attribute values used when you create a new
DEFINE and do not explicitly specify its attributes. See SET DEFINE Command
on
page S-33, RESET DEFINE Command on page R-14, and SHOW DEFINE
Command on page S-49 for more information about the working attribute set.)
LIKE other-define
specifies an existing DEFINE on which to model the new DEFINE. The new
DEFINE will be identical to the DEFINE you specify in the LIKE clause except for
specific attributes you specify with attr value pairs.
If you use the LIKE clause, you cannot specify the CLASS attribute.
attr value
specifies an attribute and its value for the new DEFINE. The attribute value pairs are
applied in the order you specify them.
If you specify the CLASS attribute, specify it first in the list of attributes. (CLASS
MAP is the default, unless the working attribute set includes a different value.)
Setting the CLASS attribute establishes a new set of attributes for the DEFINE and
sets each attribute associated with that CLASS to its initial value. If you specify
CLASS after you specify other attributes, the values you specified for the previous
attributes are erased.
See DEFINEs
on page D-26 for more information about DEFINE attributes.
ADD DEFINE { define }
{ ( define [ , define ] ... ) }
[ , LIKE other-define ] [ , attr value ] ... ;