SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-13
Running the SQL Compiler
Using a PARAM Command With the SQL Compiler
Use the TACL PARAM command to specify the BINSERV processes and the swap-file
subvolume that the SQL compiler uses for explicit SQL compilation. A PARAM
command does not apply to automatic SQL recompilation or dynamic SQL compilation.
The syntax for the PARAM command for explicit SQL compilation is:
parameter-name parameter-value
are parameter name and value pairs. These pairs apply to the SQL compiler:
BINSERV guardian-90-name
SWAPVOL subvol
BINSERV guardian-90-name
specifies the program file of the BINSERV program that the SQL compiler uses
during compilation. Follow these guidelines for guardian-name:
•
If guardian-90 - name designates a system other than the system on which
the SQL compiler is running, the BINSERV parameter is ignored.
•
If guardian-90-name does not include a volume or subvolume name, the
SQL compiler uses your current default values.
The default value for
guardian-90-name is the BINSERV program file on the
same subvolume as the SQL compiler.
SWAPVOL subvol
designates a subvolume as the location for temporary files. If you do not
specify a SWAPVOL subvolume, the SQL compiler uses your default
subvolume for temporary files.
You enter a PARAM command before you run the SQL compiler. For example:
PARAM BINSERV $talsql.utils.binserv, SWAPVOL $scratch
...
SQLCOMP /IN tobj, OUT $s.#tlst, NOWAIT / CATALOG $vol.cat
To see parameters that are currently defined, enter a PARAM command without any
parameter name and value pairs. For more information about the PARAM command,
see the
TACL Reference Manual.
PARAM [ parameter-name parameter-value ]
[ , parameter-name parameter-value ]...