SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

SyntaxDescriptionCommand
See the “SET TIME command”
(page 97).
Causes the local time of the client
workstation to be displayed as part of
the interface prompt.
SET TIME
See the“SET TIMING command”
(page 98).
Causes the elapsed time to be displayed
after each SQL statement is run.
SET TIMING
See the “SHOW ACTIVITYCOUNT
command” (page 98).
Functions as an alias of “SHOW
RECCOUNT command” (page 107).
SHOW ACTIVITYCOUNT
See the “SHOW ALIAS command”
(page 99).
Displays all or a set of aliases available
in the current RMXCI session.
SHOW ALIAS
See the “SHOW ALIASES command”
(page 100).
Displays all the aliases available in the
current RMXCI session.
SHOW ALIASES
See the “SHOW CATALOG command”
(page 100)
Displays the current default catalog.SHOW CATALOG
See the “SHOW CATALOGS
command” (page 100)
Displays all the catalogs in the current
RMXCI session
SHOW CATALOGS
See the “SHOW COLSEP command”
(page 101).
Displays the value of the column
separator for the current RMXCI session.
SHOW COLSEP
See the “SHOW ERRORCODE
command” (page 102).
Functions as an alias for the “SHOW
LASTERROR command” (page 104).
SHOW ERRORCODE
See the “SHOW FETCHSIZE
command” (page 102).
Displays the fetch size value for the
current RMXCI session.
SHOW FETCHSIZE
See the “SHOW HISTOPT command”
(page 102).
Displays the value that has been set for
the history option of the current setting.
SHOW HISTOPT
See the “SHOW IDLETIMEOUT
command” (page 103).
Displays the idle timeout value of the
current session.
SHOW IDLETIMEOUT
See the “SHOW LASTERROR
command” (page 104).
Displays the last error of the statement
that was run.
SHOW LASTERROR
See the “SHOW LIST_COUNT
command” (page 104).
Displays the maximum number of rows
to be returned by SELECT statements in
the current session.
SHOW LIST_COUNT
See the “SHOW MARKUP command”
(page 105).
Displays the value that has been set for
the markup option for the current RMXCI
session.
SHOW MARKUP
See the “SHOW PARAM command”
(page 105).
Displays the parameters that are set in
the current session.
SHOW PARAM
See the “SHOW PREPARED command”
(page 106).
Displays the prepared statements in the
current RMXCI session.
SHOW PREPARED
See the “SHOW PROCEDURES
command” (page 106).
Displays the procedures (Stored
Procedures in Java) in the current
schema of the RMXCI session.
SHOW PROCEDURES
See the “SHOW RECCOUNT
command” (page 107).
Displays the record count of the
previously run SQL statement.
SHOW RECCOUNT
See the “SHOW SCHEMA command”
(page 108).
Displays the current schema of the
RMXCI session.
SHOW SCHEMA
See the “SHOW SCHEMAS
command” (page 108).
Displays all or a set of the schemas that
exist in the default catalog of the current
session.
SHOW SCHEMAS
See the “SHOW SESSION command”
(page 109).
Displays attributes of the current RMXCI
session.
SHOW SESSION
See the “SHOW SQLPROMPT
command” (page 111).
Displays the value of the SQL prompt
for the current session.
SHOW SQLPROMPT
56 RMXCI commands