SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

MXCI Commands
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
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-4.
SET STATISTICS Command on
page 4-68
Displays statistics automatically after each SQL
statement.
SET WARNINGS Command
on
page 4-70
Sets the display of warnings within MXCI to ON or
OFF.
SH Command
on page 4-71 Invokes the shell from MXCI.
SHOW PARAM Command
on
page 4-72
Lists each parameter, and its value, defined in the
current MXCI session.
SHOW PREPARED Command
on
page 4-73
Displays the prepared statements in the current
MXCI session.
SHOW SESSION Command
on
page 4-74
Displays MXCI session attributes. You can also use
ENV.
SHOWCONTROL Command
on
page 4-76
Displays the access plan, controls, and system
defaults in effect.
SHOWDDL Command
on page 4-82 Displays the DDL syntax used to create a table,
view, or stored procedure as it exists in metadata,
SHOWLABEL Command
on
page 4-97
Displays file-label and resource-fork information for
SQL/MX objects.
SHOWSHAPE Command
on
page 4-108
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-110
Retrieves statistics from column(s) of a table.