SQL/MP Programming Manual for COBOL85

Explicit Program Compilation
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
6-27
Running the SQL Compiler in the Guardian
Environment
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.
FORCE | NOFORCE
controls how errors affect SQL compilation.
FORCE
directs the SQL compiler to produce a valid, executable object file regardless
of any syntax errors. The SQL compiler writes the SQL source statements to
the object file so that the statements can automatically be recompiled if
executed at run time. Use the FORCE option to debug a program if you do not
need to execute the SQL statements that generate errors.
NOFORCE
directs the SQL compiler to produce the SQL object program file only if there
are no syntax errors. NOFORCE is the default.
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.