SQL Supplement for H-Series RVUs

SQL/MP Programming Manual for COBOL
HP NonStop SQL Supplement for H-Series RVUs—529446-005
1-41
Running the SQL Compiler
SQL Compiler Options
CATALOG catalog-name
is the name of the catalog 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.
The SQL compiler, the object file, and the catalog must reside on the same
system.
You can also specify a CLASS catalog DEFINE name for catalog-name.
If the program was previously SQL compiled and recorded in a different catalog,
the 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 DEFINEs used to interpret DEFINE names in the SQL
statements in the program file.
CURRENTDEFINES
selects the current set of DEFINEs for compiling the program.
CURRENTDEFINES is the default.
STOREDDEFINES
selects the set of DEFINEs stored with the program the last time it was SQL
compiled. This option applies only to previously compiled SQL programs.
EXPLAIN
invokes the EXPLAIN utility.
PLAN
selects the optimized execution plan determined by the SQL compiler for DML
statements in the program. PLAN is the default.
DEFINES [ file-name ] [ , OBEYFORM ]
generates a listing of the TACL DEFINEs that the SQL compiler used to
compile the SQL statements. (The SQL compiler uses these DEFINEs to
recompile the program if you specify the STOREDDEFINES option.)