SQL/MP Programming Manual for C

Program Execution
HP NonStop SQL/MP Programming Manual for C—429847-008
7-2
Using TACL DEFINEs
temporarily gain a controlled subset of another user’s privileges. For more information
about PROGID programs, see the Security Management Guide.
Using TACL DEFINEs
Before running an SQL program file, you can specify TACL DEFINE, PARAM, or
ASSIGN commands. For information about PARAM and ASSIGN commands, see the
TACL Reference Manual.
You can use TACL DEFINE names in an SQL program to specify the names of SQL
catalogs and objects (tables, views, indexes, and partitions). Use a class CATALOG
DEFINE for a catalog and a class MAP DEFINE for an object.
You enable and disable DEFINEs using the DEFMODE attribute. If DEFMODE is ON
when a program begins execution, the system propagates the current set of DEFINEs
from the process file segment (PFS) of your TACL process to the new process. If
DEFMODE is OFF, the system propagates only the =_DEFAULTS DEFINE to the new
process. To display the current DEFMODE setting, use the SHOW DEFMODE
command.
You can create, modify, delete, and display DEFINEs with TACL (or SQLCI) commands
and Guardian system procedures. You can also specify the =_SORT_DEFAULTS
DEFINE to control sort operations.
To determine the DEFINE set used when an SQL program was compiled, use the
EXPLAIN DEFINES option of the SQLCOMP command.