SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-29
Using DEFINEs
If 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. (The
=_DEFAULTS system DEFINE is a special DEFINE that is an exception to this rule
and that is always propagated. For information, see =_DEFAULTS DEFINE on
page Z-3.)
Use these 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. For information about DEFINE-related commands in
TACL or the OSS shell, see the TACL Reference Manual or the Open System Services
Shell and Utilities Reference Manual, respectively.
Use these system procedures to work with DEFINEs from within an SQL program. For
information about the procedures, see the Guardian Procedure Calls Reference
Manual or the Open System Services System Calls Reference Manual.
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)