NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-11
ALTER DEFINE Command
ALTER DEFINE Command
ALTER DEFINE is an SQLCI command that changes the attributes of DEFINEs in the
current SQLCI session. (ALTER DEFINE is similar to the TACL command ALTER
DEFINE.)
define
is the name of an existing DEFINE to alter.
** or =*
specifies all DEFINEs.
attr value
specifies an attribute and its value for the DEFINE.
If you specify the CLASS attribute, specify it first in the list of attributes. 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.
RESET reset-list
restores the value of each attribute listed in reset-list to its initial value.
You cannot reset a required attribute, so you cannot use this clause with CLASS
MAP and CLASS CATALOG DEFINEs.
Considerations—ALTER DEFINE
•
When you end a SQLCI session, DEFINEs that you inherited from another process
(such as TACL) and modified within SQLCI revert to the values they had when you
started SQLCI. Changes you make to inherited attributes from SQLCI apply only
within SQLCI.
ALTER DEFINE define-list { , attr value } ... ;
{ , RESET reset-list}
define-list is:
{ define }
{ ( define [ , define ] ... ) }
{ ** }
{ =* }
reset-list is:
{ attr }
{ ( attr [ , attr ]... ) }