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

Welcome to the NonStop(TM) SQL/MX Remote Conversational Interface
(c) Copyright 2006-2011 Hewlett-Packard Development Company, LP.
Invalid authorization specification
User Name: super.super
Password:abc
Connected to DataSource: TDM_Default_DataSource
SQL>
After you finish logging in to the NonStop 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).
Login parameters
Instead of the default method of logging in to the NonStop SQL/MX database platform, use the
login parameters -h (or -host), -u (or -user), -p (or -password), -dsn, -q (or -sql), -s,
(or -script), -noconnect, -version and -help when launching RMXCI. For more information,
see “Logging in when launching RMXCI” (page 27).
Using optional launch parameters
To customize how to launch and log in to RMXCI, use these optional parameters:
DescriptionLaunch Parameter
Specifies the host name or IP address of the database
platform to which you want to connect the client. If you do
{-h | -host} host-name[:port-number]{-h |
-host} IP-address[:port-number]
not specify a port number, RMXCI uses the default port
number 18650. Ensure that there is a service started on
port 18650. For more information, see “Logging in when
launching RMXCI” (page 27).
Specifies the user name to log in to the database platform.
For more information, see “Logging in when launching
RMXCI” (page 27).
{-u | -user} user-name
Specifies the password for the user name to log in to the
database platform. For more information, see “Logging in
when launching RMXCI” (page 27).
{-p | -password} password
Specifies the name of a data source. If
TDM_Default_DataSource or any data source that you
-dsn data-source-name
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 instead. For more
information, see “Logging in when launching RMXCI”
(page 27).
26 Launching RMXCI