SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-7
Running the SQL Compiler
\ system
is an optional system name.
external-file
is one of these Guardian names:
[$ volume-name.][subvolume-name.] disk-file-name
$ device-name
$ device-number
$ process-name
$ spooler-collector-name[.# spooler-location-name]
If list-file does not exist, the SQL compiler creates it. If list-file already exists, the SQL
compiler appends the new output to it.
If you specify OUT but omit
list-file, the SQL compiler does not produce a listing.
If you omit OUT, the SQL compiler directs the listing to the OUT file of the invoking
process (which is usually your home terminal).
run-option
is a TACL RUN command option, as described in the TACL Reference Manual.
catalog-name
is the name of the catalog that is to hold a description of the program; catalog-
name is a subvolume name. If you partially qualify the catalog name, the system
expands the name by using your current default values.
You can also specify a TACL CLASS CATALOG DEFINE name for
catalog-name.
The catalog, object file, and SQL compiler must be on the same system.
If the program was previously SQL compiled and recorded in a different catalog,
catalog-name overrides the catalog name stored in the program file. The program
is dropped from the previous catalog and recorded in
catalog-name.
If you omit the CATALOG clause, the SQL compiler uses the current default
catalog. If you have not defined a default catalog, the SQL compiler uses your
current default subvolume.
CURRENTDEFINES | STOREDDEFINES
specifies the set of TACL DEFINEs used to interpret DEFINE names in the SQL
statements in the program file.
CURRENTDEFINES
selects the current set of TACL DEFINEs for compiling the program.
CURRENTDEFINES is the default.