SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-19
Generating an EXPLAIN DEFINES Report
Figure 5-6 on page 5-21 shows an example of an EXPLAIN PLAN report (and stored
DEFINEs).
Generating an EXPLAIN DEFINES Report
The EXPLAIN DEFINES report shows the mapping of DEFINE names used in SQL
DML, DCL, and DDL statements. This report lists:
•
Each DEFINE name and its associated NonStop Kernel operating system name
•
The default volume and default catalog used by the program (which it obtains from
the =_DEFAULTS DEFINE)
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-90-name, and define-
name would be replaced by the actual name.
Figure 5-5 on page 5-20 shows an example of the INFO DEFINE format report. In an
actual report, each instance of guardian-90-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 two 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