Neoview Command Interface (NCI) Guide (R2.3)
SQL>
At the prompt, you can enter an SQL statement or an NCI command. For more information, see
Chapter 4 (page 61).
Login Parameters
Instead of the default method of logging in to the 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 NCI. For more information, see “Logging
In When Launching NCI” (page 57).
Using Optional Launch Parameters
To customize how you launch and log in to the NCI, use these optional parameters:
DescriptionLaunch Parameter
Specifies the host name or IP address of the database
platform to which you want the client to connect. The
host-name should include the domain name of the
database platform if it is different from the domain of the
client workstation. If you do not specify a port number,
NCI uses the default port number, which is 18650. For
more information, see “Logging In When Launching NCI”
(page 57).
{-h | -host} host-name[:port-number]{-h |
-host} IP-address[:port-number]
Specifies the user name to log in to the database platform.
For more information, see “Logging In When Launching
NCI” (page 57).
{-u | -user} user-name
Specifies the password of the user to log in to the database
platform. For more information, see “Logging In When
Launching NCI” (page 57).
{-p | -password} password
Specifies the name of a data source. The recommended
data source for NCI connections is
Admin_Load_DataSource. If
Admin_Load_DataSource (or any data source that you
specify) is not started, NCI returns an error and prompts
you to close the session. If you specify a data source that
does not exist, NCI returns a warning and connects to
TDM_Default_DataSource instead. For more
information, see “Logging In When Launching NCI”
(page 57).
-dsn data-source-name
Specifies that an SQL statement or an NCI command be
run when launching the Neoview Command Interface.
You cannot specify this parameter at the same time as the
-s or -script parameter. For more information, see
“Running a Command When Launching NCI” (page 57).
{-q | -sql} "command"
Specifies that a script file be run when launching NCI in
interactive mode. You cannot specify this parameter at
the same time as the -q or -sql parameter. For more
information, see “Running a Script File When Launching
NCI” (page 58).
{-s | -script} script-file-name
Launches an NCI session without connecting to the
Neoview platform (database). For more information, see
“Launching NCI Without Connecting to the Database”
(page 59)
-noconnect
56 Launching NCI