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

Syntax
RECONNECT
Considerations
The host name or IP address and port number, credentials (user name and password) and the data
source name values are used from information previously entered. This is the information specified
at launch or when the last connect command was run.
If RMXCI was invoked with the -noconnect launch parameter, RMXCI prompts you for the values.
Examples
The following command creates a new connection to the database platform using the login
credentials of the last successful connection:
SQL>reconnect
Connected to DataSource TDM_Default_DataSource
REPEAT command
The repeat command reruns a previously run command.
Syntax
REPEAT [ text | [-]number ]
text
specifies the text of the most recently run command. The command must have been run beginning
with text, but text need be only as many characters as necessary to identify the command.
RMXCI ignores leading blanks.
[-]number
is an integer that identifies a command in the history buffer. If number is negative, it indicates
the position of the command in the history buffer relative to the current command; if number is
positive, it is the ordinal number of a command in the history buffer.
The history command displays the commands or statements in the history buffer. See the
“HISTORY command” (page 68).
Considerations
You must enter the command in one line.
To rerun the previous command, enter repeat command without specifying a number. If you
enter more than one command on a line, the repeat command reruns only the last command
on the line.
When a command is selected for repeat, and the SQL terminator value has changed since
the execution of that command, RMXCI replaces the SQL terminator in the command with the
current SQL terminator value and runs the command.
Examples
The following example displays the previously run commands and reruns the second to the
last command:
SQL>history
1> set idletimeout 0
2> log on
3> set schema persnl;
80 RMXCI commands