SQL/MP Programming Manual for COBOL

Explicit Program Compilation
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
6-31
Running the SQL Compiler in the Guardian
Environment
FORCE | NOFORCE
controls how errors affect SQL compilation.
FORCE
directs the SQL compiler to produce a valid, executable object file regardless
of syntax errors. The SQL compiler writes the SQL source statements to the
program 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 code only if there are no
syntax errors. NOFORCE is the default.
OBJECT | NOOBJECT
controls whether the compiler produces an SQL program file.
OBJECT
directs the compiler to produce a program file (depending on whether errors
occur and whether the FORCE or NOFORCE option is in effect). OBJECT is
the default.
NOOBJECT
directs the compiler to perform checking functions and to generate an
EXPLAIN listing, if requested, but not to produce a program file.
RECOMPILE | NORECOMPILE
specifies whether the program should be automatically recompiled, if necessary,
during program execution.
RECOMPILE
directs the SQL executor to automatically recompile a program whenever any
of these conditions occur:

The program file is SQL invalid.

The DEFINEs used at SQL load time are different from the DEFINEs used
during explicit SQL compilation.

The timestamp check fails for an SQL object in an SQL statement.

An access path (index) is unavailable.
RECOMPILE is the default.