SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-4
ADD DEFINE Command
Because the previous table does not show lock duration, STABLE and REPEATABLE
access options appear similar for Transaction B. For more information on lock duration,
about modifying default locking, and about the effects of locking on concurrency, see
Locking on page L-48.
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 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 HP 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. For more information
about the working attribute set, see SET DEFINE Command
on page S-32,
RESET DEFINE Command
on page R-12, and SHOW DEFINE Command on
page S-48.)
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.)
ADD DEFINE { define }
{ ( define [ , define ] ... ) }
[ , LIKE other-define ] [ , attr value ] ... ;