SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

MXCI Commands
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
4-3
For more information about utilities that you can run through MXCI, see Section 5,
SQL/MX Utilities.
For more information on entering MXCI commands, see Entering a Command on
page 1-3.
SET WARNINGS Command on
page 4-71
Sets the display of warnings within MXCI to ON or
OFF.
SH Command
on page 4-72 Invokes the shell from MXCI.
SHOW PARAM Command
on
page 4-73
Lists each parameter, and its value, defined in the
current MXCI session.
SHOW PREPARED Command
on
page 4-74
Displays the prepared statements in the current
MXCI session.
SHOW SESSION Command
on
page 4-75
Displays MXCI session attributes. You can also use
ENV.
SHOWCONTROL Command
on
page 4-77
Displays the access plan, controls, and system
defaults in effect.
SHOWDDL Command
on page 4-83 Displays the DDL syntax used to create a table,
view, sequence generator or stored procedure as it
exists in metadata,
SHOWLABEL Command
on
page 4-99
Displays file-label and resource-fork information for
SQL/MX objects.
SHOWSHAPE Command
on
page 4-110
Displays the control query shape for a given DML
statement. The result can be used at a later time to
force the same access plan.
SHOWSTATS Command
on
page 4-112
Retrieves statistics from column(s) of a table.