SQL/MX 2.x Reference Manual (H06.04+)

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