SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-8
Running the SQL Compiler
STOREDDEFINES
selects set of TACL DEFINEs stored with the program the last time it was SQL
compiled. This option applies only to programs that have been SQL compiled.
FORCE | NOFORCE
controls how syntax 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.
You can 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 file only if there are no
syntax errors. NOFORCE is the default.
[ EXPLAIN ]
[ [ PLAN ] ]
[ [ DEFINES[ file-name ][, OBEYFORM ] ] ]
[ ]
[ NOEXPLAIN ]
controls whether the compiler invokes the EXPLAIN utility.
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 TACL DEFINEs used to SQL compile the SQL statements. The
DEFINEs appear at the end of the SQL compiler listing. These DEFINEs are
the ones that would be used if you were to recompile the program with the
STOREDDEFINES option.
file-name
is the destination where the DEFINE listing is written. The destination is an
external-file as described for OUT list-file.