NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-28
Using DEFINEs
Use the following commands to work with DEFINEs from SQLCI. Each command is
described in more detail in a separate entry.
TACL has similar commands with the same names as the SQLCI commands just listed.
The OSS shell has similar commands, add_define, del_define, info_define, set_define,
and show_define. See the TACL Reference Manual or the OSS Shell and Utilities
Reference Manual for more information about DEFINE-related commands in TACL or
the OSS shell, respectively.
Use the following system procedures to work with DEFINEs from within an SQL
program. See the Guardian Procedure Calls Reference Manual or the OSS System Calls
Reference Manual for more information about the procedures.
ADD DEFINE Adds a DEFINE
ALTER DEFINE Changes attributes of DEFINEs
DELETE DEFINE Deletes DEFINEs
INFO DEFINE Displays DEFINE attribute values
RESET DEFINE Restores DEFINE attributes in the working set to their initial values
SET DEFINE Establishes values for DEFINE attributes in the working set
SET DEFMODE Enables or disables the use of all DEFINEs in the current session and
enables or disables the propagation of DEFINEs from the current
session
SHOW DEFINE Displays DEFINE attribute values for the working attribute set
SHOW
DEFMODE
Displays the current DEFMODE setting
DEFINEADD Adds a DEFINE
CHECKDEFINE Checkpoints a DEFINE to a backup process
DEFINEDELETE Deletes DEFINEs
DEFINEDELETEALL Deletes all DEFINEs except =_DEFAULTS from the context
of the current process
DEFINEINFO Returns DEFINE attribute values
DEFINEMODE Enables or disables the use of DEFINEs
DEFINENEXTNAME Returns the next DEFINE name (DEFINEs are stored in
ascending order by name)
DEFINEREADATTR Returns an attribute value for a DEFINE or for the working
attribute set
DEFINERESTOREWORK Restores the working attribute set from the background set
DEFINESAVEWORK Saves the working attribute set in the background set