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

SyntaxDescriptionCommand
See the “OBEY command” (page 74).Runs the SQL statements and RMXCI
interface commands contained in a
specified script file.
OBEY
See the “PRUN command” (page 77).Runs script files in parallel.PRUN
See the “QUIT command” (page 79).Disconnects from and exits RMXCI.QUIT
See the “RECONNECT command”
(page 79).
Creates a new connection to the
NonStop platform using the login
RECONNECT
credentials of the last successful
connection.
See the “REPEAT command”
(page 80).
Reruns a command.REPEAT
See the “RESET LASTERROR command”
(page 81).
Resets the last error code to 0.RESET LASTERROR
See the “RESET PARAM command”
(page 82).
Clears all parameter values or a
specified parameter value in the current
session.
RESET PARAM
See the “RUN command” (page 82).Runs the previously run SQL statement.RUN
See the “SAVEHIST command”
(page 83).
Saves the session history in a
user-specified file.
SAVEHIST
See the “SHOW SESSION command”
(page 109).
Displays attributes of the current RMXCI
session.
SESSION
See the “SET CATALOG command”
(page 83).
Sets the current catalogSET CATALOG
See the “SET COLSEP command”
(page 84).
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 85).
Changes the default fetchsize used by
NonStop JDBC Type 4 Driver.
SET FETCHSIZE
See the “SET HISTOPT command”
(page 86).
Sets the history option and controls how
commands are added to the history
buffer.
SET HISTOPT
See the “SET IDLETIMEOUT command”
(page 87).
Sets the idle timeout value for the current
session.
SET IDLETIMEOUT
See the “SET LIST_COUNT command”
(page 87).
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 89).
Sets the markup format and controls
how results are displayed by RMXCI.
SET MARKUP
See the “SET PARAM command”
(page 92).
Sets a parameter value in the current
session.
SET PARAM
See the “SET PROMPT command”
(page 93).
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 94).
Sets the SQL prompt of the current
session to a specified string. The default
is SQL.
SET SQLPROMPT
See the “SET SQLTERMINATOR
command” (page 96).
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 96).
Automatically retrieves the statistics
information for a query being run.
SET STATISTICS
55