SQL/MP Programming Manual for COBOL

Explicit Program Compilation
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
6-30
Running the SQL Compiler in the Guardian
Environment
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.)
file-name
is the destination to which the DEFINE listing is written in addition to the
compiler listing. See list-file
for a description.
OBEYFORM
directs the SQL compiler to write the DEFINE listing in an OBEY
command-file format so that you can use an OBEY command to set the
DEFINEs. If you omit OBEYFORM, the SQL compiler uses the format
displayed by the TACL INFO DEFINE command. If you omit DEFINES, the
SQL compiler does not generate a DEFINE listing.
NOEXPLAIN
disables the EXPLAIN utility. NOEXPLAIN is the default.