SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-6
Running the SQL Compiler
before you run the SQL compiler. For more information about the Accelerator, see the
Binder Manual and DLL Programmer’s Guide for TNS/R Systems.
Running the SQL Compiler
The SQL compiler generates SQL object code in the Pascal object file. SQL
compilation also verifies the SQL objects used in SQL statements and generates an
optimized execution plan for each SQL statement. Optionally, you can invoke the
EXPLAIN utility to produce a report on the execution plans for SQL DML statements
and the DEFINEs used by the program. (For a complete list of SQL compiler functions,
see Functions of the SQL Compiler on page 5-11).
To run the SQL compiler, use the SQLCOMP command. The syntax is:
object-file
is a NonStop Kernel operating system file name that represents the target object
file generated by the compiler. This target object file cannot be in a user library or a
system library. The object file can be generated by the:
•
Pascal compiler
•
Binder program
•
SQL compiler
•
Accelerator
SQLCOMP / IN object-file [ , OUT [ list-file ] ]
[ compiler-option [ , compiler-option ] ... ]
compiler-option is:
[ CATALOG catalog-name ]
[ CURRENTDEFINES | STOREDDEFINES ]
[ EXPLAIN ]
[ [ PLAN ] ]
[ [ DEFINES [ file-name ] [, OBEYFORM ] ] ]
[ ]
[ NOEXPLAIN ]
[ FORCE | NOFORCE ]
[ OBJECT | NOOBJECT ]
[ RECOMPILE | NORECOMPILE ]
[ RECOMPILEONDEMAND | RECOMPILEALL ]