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

condition
is the same as the condition parameter defined for the “IF...THEN command” (page 91). See
“Condition Parameter” (page 91).
Considerations
You must enter the command in one line.
Examples
• The following command disconnects from the database platform and exits RMXCI:
SQL>quit
• If the previously run command returns the error code 4082, the conditional exit command
stops running the script file and then disconnects and exits from RMXCI.
log /usr/home/rmxci/log/errorCode.log
select * from employee;
quit if errorcode=4082
log off
The following results are logged on getting error 4082:
SQL>select * from employee;
*** ERROR[4082] Table, view or stored procedure
NONSTOP_SYSTEM_NSK.PUBLIC_ACCESS_SCHEMA.USR.EMPLOYEE
does not exist or is inaccessible.
SQL>quit if errorcode=4082
RECONNECT command
The reconnect command creates a new connection to the database platform using the login
credentials of the last successful connection.
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 ]
102 RMXCI commands