SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-20
Generating an EXPLAIN DEFINES Report
Figure 5-6 on page 5-21 shows an EXPLAIN report that includes both the execution
plans and stored DEFINEs. The EXPLAIN sample listing shows the SQL compiler
options in effect, a portion of the execution plan, and the DEFINEs report in the OBEY
command file format.
Figure 5-5. INFO DEFINE Format of the EXPLAIN DEFINES Report
VST0505.vsd
DEFINE NAME define - name
CLASS MAP
FILE guardian-90-name
DEFINE NAME define - name
CLASS MAP
FILE guardian-90-name
DEFINE NAME =_DEFAULTS
CLASS DEFAULTS
VOLUME guardian-90-name
CATALOG guardian-90-name