SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-9
Running the SQL Compiler
OBEYFORM
specifies writing the TACL DEFINE list in OBEY format so that you can
enter an OBEY command from your TACL prompt to set the DEFINEs
before 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, a DEFINE listing is not 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 whether the FORCE or NOFORCE option is in
effect).
OBJECT is the default.
NOOBJECT
directs the compiler to perform checking functions, to generate an
EXPLAIN listing if you have also specified EXPLAIN, and 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
all of these conditions occur at run time:
•
The program file is marked invalid.
•
Run-time TACL 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 it was not marked because the
program was network-inaccessible or already executing.
•
An access path is unavailable.
RECOMPILE is the default.