SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-31
Using TACL DEFINEs
an implicit RUN command, enter only the name of the program file. The syntax for the
RUN command is:
RUN
executes the program file without debugging.
RUND
executes the program file and initiates debugging under the control of INSPECT or
DEBUG.
program-file
is the name of the SQL program object file.
run-option
is a run option of the RUN command, as described in the TACL Reference Manual.
param-set
is a list of one or more parameters to pass to the program, with each parameter
separated by a space, as described in the
TACL Reference Manual.
Using TACL DEFINEs
A DEFINE is a named set of attributes and associated values stored in the process file
segment (PFS) of a process. TACL DEFINEs allow you to specify information about a
process before you run the process. You specify this information by entering TACL
DEFINE commands at your TACL or SQLCI prompt, or by calling Guardian system
procedure calls (or a by a combination of both command and procedure calls).
With NonStop SQL, you can use TACL DEFINE names in your program to specify the
names of catalogs, tables, views, indexes, partitions, and other programs.
If you use TACL DEFINE names in SQL statements to refer to the above SQL objects,
follow the guidelines listed below. For more information about using TACL DEFINEs
with NonStop SQL, see the
SQL/MP Reference Manual.
TAL Compilation
For TAL compilation, set TACL DEFINEs for any DEFINE names of tables or views you
use in INVOKE directives.
[ RUN[D] ] program-file
[ / run-option [ , run-option ] ... / ] [ param-set ]