SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

MXCI Commands
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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-3.
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-95
Displays file-label and resource-fork information for
SQL/MX objects.
SHOWSHAPE Command
on
page 4-106
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.