SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-50
SET SHOWSHAPE Command
SET SHOWSHAPE Command
Considerations for SET SHOWSHAPE
Examples of SET SHOWSHAPE
The SET SHOWSHAPE command allows you to display access plans in effect. The
effect of SET SHOWSHAPE is to generate the output of the SHOWSHAPE command
for multiple SQL statements. See SHOWSHAPE Command on page 4-89.
You can use SET SHOWSHAPE only within an MXCI session.
ON
displays the access plans in effect for executed queries. The control query shape
is displayed immediately before the query output.
OFF
turns off the display of access plans.
INFILE infile-name OUTFILE outfile-name
allows you to specify the name of an input file of SQL statements and the name of
an output file that is the result of executing the input file. The output file includes
the control query shape for each query in the input file.
infile-name
is the full or relative path name of an input file that contains MXCI commands
and SQL statements to be executed by an OBEY command. See OBEY
Command on page 4-41.
outfile-name
is the full or relative path name of an output file to which are written the results
of queries and their access plans. The query output is the result of the
execution of the input OBEY command file infile-name. The control query
shape for each query is displayed immediately before the query text.
SET SHOWSHAPE showshape-option
showshape-option is:
ON
| OFF
| INFILE infile-name OUTFILE outfile-name
Note. The default setting when you start MXCI is SHOWSHAPE OFF.