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

Host Name/IP Address:
Enter a host name:
host-name[:port-number]
Enter a host name:
host-name[:port-number]
If you do not specify a port number, RMXCI uses the default port number18650. Ensure
that a service has started on port 18650.
Or enter an IP address:
IP-address[:port-number]
2. Enter your user name.
3. Enter your password.
4. Enter the name of a data source that is available and started.
If you do not enter a data source, by default, RMXCI connects to TDM_Default_DataSource.
If TDM_Default_DataSource or any data source which you specify is not started, RMXCI
returns an error and prompts you to close the session. If you specify a data source that does
not exist, RMXCI returns a warning and connects to TDM_Default_DataSource.
After you finish logging in to the SQL/MX database, the SQL prompt appears as shown:
Welcome to the NonStop(TM) SQL/MX Remote Conversational Interface
(c) Copyright 2006-2011 Hewlett-Packard Development Company, LP.
Host Name/IP Address: nsksys.ind.hp.com:18650
User Name: super.super
Password:
DataSource Name [TDM_Default_DataSource]:
Connected to DataSource: TDM_Default_DataSource
SQL>
At the prompt, you can enter an SQL statement or a RMXCI command. For more information, see
Chapter 4 (page 33).
NOTE: RMXCI enables you to re-enter the login parameters with a maximum of three retries,
before it exits from the session.
The retry logic is applied as follows:
If a connection fails due to an invalid host name, RMXCI prompts only for the host name
parameter.
If the login fails due to invalid user name or password, RMXCI prompts only for the user name
and password.
If the login fails with an error stating that the data source is not started, RMXCI does not prompt
for the options again.
If all the login parameters are invalid, RMXCI prompts only for the host name. When a valid
host name is entered, RMXCI prompts for the user name and password.
The retry logic applies to connect and reconnect commands. For the reconnect command,
this applies only when no prior connection has been established (-noconnect).
If the -q parameter or -version is included on the command line, RMXCI does not prompt for
retries. If the -s parameter is included on the command line, RMXCI prompts for retries.
24 Launching RMXCI