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

HP NonStop SQL/MX Reference Manual—544517-008
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 USE OF SOURCE
on
page 4-13
Displays all modules and their corresponding
source SQL files.
DISPLAY USE OF ALL | INVALID
MODULES on page 4-15
Displays all / Invalid modules along with their
corresponding source SQL files for a given object
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-63.
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-47.
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-33 Displays recently executed commands.
INFO DEFINE Command
on
page 4-34
Displays current DEFINEs.
INVOKE Command
on page 4-35 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-64.
LOG Command
on page 4-36 Starts or ends session logging to a file.
LS Command
on page 4-40 Lists file statistics.