SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-8
Running the SQL Compiler
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 programs that previously have been SQL
compiled.
FORCE | NOFORCE
controls how errors affect SQL compilation.
FORCE
directs the SQL compiler to produce a valid, executable program file regardless
of errors. The SQL compiler stores the SQL source statements with errors in
the object program file and produces no output for the statements. At run time,
the lack of output forces automatic recompilation.
Any error that exists at explicit SQL compilation time would also be an error at
run time, so the typical use of this option is to debug programs when you are
not concerned about executing the SQL statements that produce 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
enables 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 ]
displays the DEFINEs used to SQL compile the SQL statements. The
DEFINEs appear at the end of the SQL compiler listing. These DEFINEs
are those that would be used if you were to recompile the program with the
STOREDDEFINES option.