SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-20
Using the EXPLAIN Utility
Figure 5-6 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