SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-2
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.
MODE Command on page 4-43 Changes command mode.
MXCI Command
on page 4-44 Starts an MXCI session from the OSS environment.
OBEY Command
on page 4-45 Executes MXCI commands and statements from a
file. This file is referred to as an OBEY command
file.
REPEAT Command
on page 4-47 Reexecutes a command. You can also use the
exclamation point (!) command.
RESET PARAM Command
on
page 4-48
Clears the values of the specified parameter or all
the parameters in the current session.
SET LIST_COUNT Command
on
page 4-50
Sets the maximum number of rows to be displayed
for the next SELECT statement.
SET PARAM Command
on page 4-51 Sets a value for a parameter used in queries to be
executed.
SET SHOWSHAPE Command
on
page 4-54
Displays the access plans in effect. Generates the
output of the SHOWSHAPE command for multiple
SQL statements.
SET STATISTICS Command
on
page 4-57
Displays statistics automatically after each SQL
statement.
SET WARNINGS Command
on
page 4-59
Sets the display of warnings within MXCI to ON or
OFF.
SH Command
on page 4-60 Invokes the shell from MXCI.
SHOW PARAM Command
on
page 4-61
Lists each parameter, and its value, defined in the
current MXCI session.
SHOW PREPARED Command
on
page 4-62
Displays the prepared statements in the current
MXCI session.
SHOW SESSION Command
on
page 4-63
Displays MXCI session attributes. You can also use
ENV.
SHOWCONTROL Command
on
page 4-65
Displays the access plan, controls, and system
defaults in effect.
SHOWDDL Command
on page 4-71 Displays the DDL syntax used to create a table,
view, or stored procedure as it exists in metadata,
SHOWLABEL Command
on
page 4-84
Displays file-label and resource-fork information for
SQL/MX objects.
SHOWSHAPE Command
on
page 4-95
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.