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

SyntaxDescriptionCommand
See the “OBEY command” (page 96).Runs the SQL statements and RMXCI
interface commands contained in a
specified script file.
OBEY
See the “PRUN command” (page 99).Runs script files in parallel.PRUN
See the “QUIT command” (page 101).Disconnects from and exits RMXCI.QUIT
See the “RECONNECT command”
(page 102).
Creates a new connection to the
SQL/MX database using the login
RECONNECT
credentials of the last successful
connection.
See the “REPEAT command”
(page 102).
Reruns a command.REPEAT
See the “RESET LASTERROR command”
(page 104).
Resets the last error code to 0.RESET LASTERROR
See the “RESET PARAM command”
(page 104).
Clears all parameter values or a
specified parameter value in the current
session.
RESET PARAM
See the “RUN command” (page 105).Runs the previously run SQL statement.RUN
See the “SAVEHIST command”
(page 105).
Saves the session history in a
user-specified file.
SAVEHIST
See the “SHOW SESSION command”
(page 132).
Displays attributes of the current RMXCI
session.
SESSION
See the “SET CATALOG command”
(page 106).
Sets the current catalogSET CATALOG
See the “SET COLSEP command”
(page 107).
Sets the column separator and allows
you to control the formatting of the result
displayed for SQL queries.
SET COLSEP
See the “SET FETCHSIZE command”
(page 108).
Changes the default fetchsize used by
NonStop JDBC Type 4 Driver.
SET FETCHSIZE
See the “SET HISTOPT command”
(page 108).
Sets the history option and controls how
commands are added to the history
buffer.
SET HISTOPT
See the “SET IDLETIMEOUT command”
(page 110).
Sets the idle timeout value for the current
session.
SET IDLETIMEOUT
See the “SET LIST_COUNT command”
(page 110).
Sets the maximum number of rows to be
returned by SELECT statements that are
run after this command.
SET LIST COUNT
See the“SET MARKUP command”
(page 111).
Sets the markup format and controls
how results are displayed by RMXCI.
SET MARKUP
See the “SET PARAM command”
(page 114).
Sets a parameter value in the current
session.
SET PARAM
See the “SET PROMPT command”
(page 116).
Sets the prompt of the current session to
a specified string or to a session
SET PROMPT
variable. This command is an alias for
SET SQLPROMPT command.
See the “SET SQLPROMPT command”
(page 117).
Sets the SQL prompt of the current
session to a specified string. The default
is SQL.
SET SQLPROMPT
See the “SET SQLTERMINATOR
command” (page 118).
Sets the SQL statement terminator of the
current session to a specified string. The
default is a semicolon (;).
SET SQLTERMINATOR
See the “SET STATISTICS command”
(page 119).
Automatically retrieves the statistics
information for a query being run.
SET STATISTICS
77