SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-19
Using the EXPLAIN Utility
You can have the EXPLAIN utility generate the EXPLAIN DEFINES report in either of
these formats:
Figure 5-4
shows an example of the OBEY command file format report. In an actual
report, each instance of subvolume-name, guardian-name, and define-name would be
replaced by the actual name
.
Figure 5-5 shows an an example of the INFO DEFINE format report. In an actual
report, each instance of
guardian-name and define-name would be replaced by the
actual name.
OBEY command file
format
The EXPLAIN utility generates the TACL ADD DEFINE
commands for the DEFINEs. You can subsequently use the
TACL OBEY command to generate the commands in the file.
INFO DEFINE format The EXPLAIN utility uses the format produced by the TACL
INFO DEFINE command.
Figure 5-4. OBEY Command File Format of the EXPLAIN DEFINES Report
Note. When you issue an OBEY command using the OBEY command file format to compile or
execute a program, ensure that these TACL DEFINE parameters are set as follows:
SET DEFMODE ON
SET DEFINE CLASS MAP
. . .
ALTER DEFINE = _DEFAULTS, VOLUME subvolume-name
ADD DEFINE = define-name, FILE guardian-90-name
ADD DEFINE =
define-name, FILE guardian-90-name
ALTER DEFINE = _DEFAULTS, CATALOG subvolume-name
VST0504.vsd