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

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
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-4 Creates DEFINEs for Guardian file names.
ALTER DEFINE Command
on
page 4-6
Changes DEFINEs for Guardian file names.
CD Command
on page 4-8 Changes the current working directory.
DELETE DEFINE Command
on
page 4-9
Deletes current DEFINEs.
DISPLAY USE OF Command
on
page 4-10
Displays usage information on compiled modules.
DISPLAY USE OF SOURCE
on
page 4-14
Displays all modules and their corresponding
source SQL files.
DISPLAY USE OF ALL | INVALID
MODULES on page 4-16
Displays all / Invalid modules along with their
corresponding source SQL files for a given object
DISPLAY_QC Command
on
page 4-19
Generates and displays selected data from the
result of the QUERYCACHE function.
DISPLAY_QC_ENTRIES Command
on page 4-21
Generates and displays selected data from the
result of the QUERYCACHEENTRIES function.
DISPLAY STATISTICS Command
on
page 4-23
Displays statistics about the last DML or PREPARE
statement you executed.
ENV Command
on page 4-25 Displays MXCI session attributes. You can also use
the SHOW SESSION Command
on page 4-74.
ERROR Command
on page 4-27 Displays error text.
Exclamation Point (!) Command
on
page 4-28
Reexecutes a command. You can also use the
REPEAT Command
on page 4-58.
EXIT Command
on page 4-29 Ends an MXCI session.
FC Command
on page 4-30 Edits and reexecutes a previous command.
GET NAMES OF RELATED NODES
Command on page 4-34
Displays the names of the transitive closure of
nodes that are related to the specified node.
GET NAMES OF RELATED
SCHEMAS Command on page 4-35
Displays the names of the transitive closure of
schemas related to the specified schema.
GET NAMES OF RELATED
CATALOGS on page 4-36
Displays the names of the transitive closure of
catalogs related to the specified catalog.
GET VERSION OF SYSTEM
on
page 4-37
Displays SQL/MX Software Version.
GET VERSION OF SCHEMA
Command on page 4-38
Displays the schema version of the specified
schema.