SQL/MP Programming Manual for COBOL85

Explicit Program Compilation
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
6-28
Running the SQL Compiler in the Guardian
Environment
DEFINES [ file-name ] [ , OBEYFORM ]
generates a listing of the TACL DEFINEs that the SQL compiler used to
compile the SQL statements. (The SQL compiler uses these DEFINEs to
recompile the program if the STOREDDEFINES option is specified.)
file-name
is the destination to which the DEFINE listing is written in addition to the
compiler listing. See list-file for a description.
OBEYFORM
directs the SQL compiler to write the DEFINE listing in an OBEY
command-file format so that you can use an OBEY command to set the
DEFINEs. If you omit OBEYFORM, the SQL compiler uses the format
displayed by the TACL INFO DEFINE command. If you omit DEFINES, the
SQL compiler does not generate a DEFINE listing.
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 produce a 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 requested, but not to produce a 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 any
of these conditions occur:
•
The program file is SQL invalid.
•
The DEFINEs at SQL load time are different then the DEFINEs used
during explicit SQL compilation.
•
The timestamp check fails for an SQL object in an SQL statement.