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

HP NonStop SQL/MX Reference Manual—540440-003
4-1
4 MXCI Commands
This section describes the syntax and semantics of MXCI commands. MXCI
commands are NonStop SQL/MX extensions that typically affect attributes of an MXCI
session. You can run these commands only through MXCI, with the exceptions noted:
ADD DEFINE Command on page 4-3 Creates DEFINEs for Guardian file names.
ALTER DEFINE Command
on
page 4-5
Changes DEFINEs for Guardian file names.
CD Command
on page 4-7 Changes the current working directory.
DELETE DEFINE Command
on
page 4-8
Deletes current DEFINEs.
DISPLAY USE OF Command
on
page 4-9
Displays usage information on compiled modules.
DISPLAY_EXPLAIN Command
on
page 4-13
Displays a statement’s access plan as the result
table of the EXPLAIN function.
DISPLAY_QC Command
on
page 4-18
Generates and displays selected data from the
result of the QUERYCACHE function.
DISPLAY_QC_ENTRIES Command
on page 4-20
Generates and displays selected data from the
result of the QUERYCACHEENTRIES function.
DISPLAY STATISTICS Command
on
page 4-22
Displays statistics about the last DML or PREPARE
statement you executed.
ENV Command
on page 4-24 Displays MXCI session attributes. You can also use
the SHOW SESSION Command on page 4-59.
ERROR Command
on page 4-26 Displays error text.
Exclamation Point (!) Command
on
page 4-27
Reexecutes a command. You can also use the
REPEAT Command
on page 4-43.
EXIT Command
on page 4-28 Ends an MXCI session.
FC Command
on page 4-29 Edits and reexecutes a previous command.
HISTORY Command
on page 4-31 Displays recently executed commands.
INFO DEFINE Command
on
page 4-32
Displays current DEFINEs.
INVOKE Command
on page 4-33 Displays a record description for the specified table
or view. Can also be run as embedded SQL to
create a C structure or COBOL record. See
INVOKE Directive
on page 3-63.
LOG Command
on page 4-34 Starts or ends session logging to a file.
LS Command
on page 4-36 Lists file statistics.
MODE Command
on page 4-39 Changes command mode.
MXCI Command
on page 4-40 Starts an MXCI session from the OSS environment.