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

MXCI Commands
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
4-2
GET VERSION OF SYSTEM
SCHEMA Command on page 4-39
Displays the system schema version of the
specified node.
GET VERSION OF Object Command
on page 4-40
Displays the object schema version (OSV) and the
object feature version (OFV) of the specified
database object.
GET VERSION OF MODULE
Command on page 4-41
Displays the module version of the specified
module.
GET VERSION OF PROCEDURE
Command on page 4-42
Displays the plan version of the specified procedure
in the specified module.
GET VERSION OF STATEMENT
Command on page 4-43
Displays the plan version of the specified prepared
statement.
HISTORY Command
on page 4-44 Displays recently executed commands.
INFO DEFINE Command
on
page 4-45
Displays current DEFINEs.
INVOKE Command
on page 4-46 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-47 Starts or ends session logging to a file.
LS Command
on page 4-51 Lists file statistics.
MODE Command
on page 4-54 Changes command mode.
MXCI Command
on page 4-55 Starts an MXCI session from the OSS environment.
OBEY Command
on page 4-56 Executes MXCI commands and statements from a
file. This file is referred to as an OBEY command
file.
REPEAT Command
on page 4-58 Reexecutes a command. You can also use the
exclamation point (!) command.
RESET PARAM Command
on
page 4-59
Clears the values of the specified parameter or all
the parameters in the current session.
SET LIST_COUNT Command
on
page 4-61
Sets the maximum number of rows to be displayed
for the next SELECT statement.
SET PARAM Command
on page 4-62 Sets a value for a parameter used in queries to be
executed.
SET SHOWSHAPE Command
on
page 4-65
Displays the access plans in effect. Generates the
output of the SHOWSHAPE command for multiple
SQL statements.
SET STATISTICS Command
on
page 4-68
Displays statistics automatically after each SQL
statement.
SET WARNINGS Command
on
page 4-70
Sets the display of warnings within MXCI to ON or
OFF.