SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-9
Running the SQL Compiler
file-name
is the destination to which the DEFINE listing is written in addition to
the compiler listing. The file is an external-file as described for
OUT list-file.
OBEYFORM
specifies writing the DEFINE list in an OBEY format so that you can
enter an OBEY command from your TACL prompt to set the DEFINEs
at run time or compile time. If you omit OBEYFORM, the listing is in the
format displayed by the INFO DEFINE command. If you omit
DEFINES, no DEFINE listing is generated.
NOEXPLAIN
disables the EXPLAIN utility. NOEXPLAIN is the default.
OBJECT | NOOBJECT
controls whether the compiler produces an SQL program file.
OBJECT
directs the compiler to generate an SQL program file (depending on whether
errors occur and 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 you have also specified EXPLAIN, but not to produce an
SQL program file.
RECOMPILE | NORECOMPILE
specifies whether the program should be automatically recompiled, if necessary.
RECOMPILE
directs the SQL compiler to automatically recompile a program whenever the
conditions shown below occur at run time. RECOMPILE is the default.
•
The program file is invalid.
•
Run-time DEFINEs are different from SQL compile-time DEFINEs.
•
The timestamp check on file opens indicate that the program should have
been marked as invalid, but was not marked because the program was
network-inaccessible or already executing.
•
An access path is unavailable.