SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-5
Running the Accelerator
When you run the TAL compiler, use the SEARCH directive to include the TALLIB run-
time library. This SEARCH directive appears in a TAL source file:
! TAL source file
?SEARCH ($system.system.TALLIB)
...
You can also specify the SEARCH directive in the command line for the TAL compiler:
TAL /IN partsrc, OUT $s.#partlst, NOWAIT / partobj ; SQL ,
SEARCH ($system.system.TALLIB)
These Binder commands build an object file named PROGOBJ that includes the
TALLIB library:
ADD * FROM progobj
SELECT SEARCH $system.system.TALLIB
BUILD progobj !
Running the Accelerator
If your object file will run on a TNS/R system, you can run the Accelerator to optimize
the object code. Because the Accelerator invalidates SQL object files, you must run it
before you run the SQL compiler. For more information about the Accelerator, see the
Programmer’s Guide for TNS/R Systems and the Accelerator Manual.
Running the SQL Compiler
The SQL compiler generates SQL object code in the TAL 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 TACL
DEFINEs used by the program. (For a complete list of SQL compiler functions, see
What Does the SQL Compiler Do?
on page 5-11.