SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-14
Running the SQL Compiler
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-90-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.
•
If you omit guardian-90-name, the SQL compiler uses the name
BINSERV.
The default value for guardian-90-name is the BINSERV program file on the
same subvolume as the SQL compiler.
SWAPVOL subvol
designates a specified 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 $PASSQL.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 commands,
see the TACL Reference Manual.
Interpreting SQL Compiler Messages
The SQL compiler issues messages for error and warning conditions. An error can
prevent successful compilation of a program file, but a warning does not prevent
successful compilation. For more information on the description of all SQL compiler
messages, see the SQL/MP Messages Manual.
PARAM [ parameter-name parameter-value ]
[ , parameter-name parameter-value ]...