SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

SyntaxDescriptionCommand
See the “SET TIME command”
(page 120).
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 120).
Causes the elapsed time to be displayed
after each SQL statement is run.
SET TIMING
See the “SHOW ACTIVITYCOUNT
command” (page 121).
Functions as an alias of “SHOW
RECCOUNT command” (page 130).
SHOW ACTIVITYCOUNT
See the “SHOW ALIAS command”
(page 121).
Displays all or a set of aliases available
in the current RMXCI session.
SHOW ALIAS
See the “SHOW ALIASES command”
(page 122).
Displays all the aliases available in the
current RMXCI session.
SHOW ALIASES
See the “SHOW CATALOG command”
(page 123)
Displays the current default catalog.SHOW CATALOG
See the “SHOW CATALOGS
command” (page 123)
Displays all the catalogs in the current
RMXCI session
SHOW CATALOGS
See the “SHOW COLSEP command”
(page 124).
Displays the value of the column
separator for the current RMXCI session.
SHOW COLSEP
See the “SHOW ERRORCODE
command” (page 124).
Functions as an alias for the “SHOW
LASTERROR command” (page 126).
SHOW ERRORCODE
See the “SHOW FETCHSIZE
command” (page 125).
Displays the fetch size value for the
current RMXCI session.
SHOW FETCHSIZE
See the “SHOW HISTOPT command”
(page 125).
Displays the value that has been set for
the history option of the current setting.
SHOW HISTOPT
See the “SHOW IDLETIMEOUT
command” (page 125).
Displays the idle timeout value of the
current session.
SHOW IDLETIMEOUT
See the “SHOW LASTERROR
command” (page 126).
Displays the last error of the statement
that was run.
SHOW LASTERROR
See the “SHOW LIST_COUNT
command” (page 127).
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 127).
Displays the value that has been set for
the markup option for the current RMXCI
session.
SHOW MARKUP
See the “SHOW PARAM command”
(page 127).
Displays the parameters that are set in
the current session.
SHOW PARAM
See the “SHOW PREPARED command”
(page 128).
Displays the prepared statements in the
current RMXCI session.
SHOW PREPARED
See the “SHOW PROCEDURES
command” (page 129).
Displays the procedures (Stored
Procedures in Java) in the current
schema of the RMXCI session.
SHOW PROCEDURES
See the “SHOW RECCOUNT
command” (page 130).
Displays the record count of the
previously run SQL statement.
SHOW RECCOUNT
See the “SHOW SCHEMA command”
(page 130).
Displays the current schema of the
RMXCI session.
SHOW SCHEMA
See the “SHOW SCHEMAS
command” (page 131).
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 132).
Displays attributes of the current RMXCI
session.
SHOW SESSION
See the “SHOW TABLES command”
(page 135).
Displays the value of the SQL prompt
for the current session.
SHOW SQLPROMPT
78 RMXCI commands