SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-35
Using DEFINEs
When DEFMODE is OFF, DEFINEs are ignored, and you cannot create new DEFINEs.
You can still modify, delete, and display information about existing DEFINEs, but such
DEFINEs have no effect because they are not propagated to other programs.
Use these commands to work with DEFINEs from MXCI. Each command is described
in more detail in a separate entry.
TACL has similar commands with the same names as the MXCI 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 Open System Services
Shell and Utilities Reference Manual for more information about DEFINE-related
commands in TACL or the OSS shell, respectively.
Use these system procedures to work with DEFINEs from within an SQL program. See
the Guardian Procedure Calls Reference Manual or the Open System Services System
Calls Reference Manual for more information about the procedures.
ADD DEFINE Command
on page 4-3
Adds a DEFINE in the current MXCI session
ALTER DEFINE
Command on page 4-5
Changes the physical name of a DEFINE in the current MXCI
session
DELETE DEFINE
Command on page 4-8
Deletes a DEFINE in the current MXCI session
INFO DEFINE Command
on page 4-32
Displays the logical and physical names of DEFINEs in the
current MXCI session
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
DEFINEEXTNAME 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
DEFINESETATTR Alters the value of an attribute in the working set, or resets the
attribute
DEFINESETLIKE Sets all attributes of the working set to match those of an
existing DEFINE
DEFINEVALIDATEWORK Checks the working set for consistency and completeness