Neoview Command Interface (NCI) Guide (R2.4)

DescriptionLaunch Parameter

Displays the build version of NCI and the Neoview JDBC

Type 4 Driver. Upon completion of the display, the client

exits. If any other parameters are included with the

-version parameter, they are ignored. For more

information, see “Running NCI With -version” (page 58).

-version

Displays a list of accepted arguments with descriptions

and then exits. For more information, see “Running NCI

With -version” (page 58).

-help

Logging In When Launching NCI

To avoid entering a host name, user name, password, or data source when NCI launches, use

the -h (or -host), -u (or -user), -p (or -password), or -dsn command-line parameters.

NOTE: You can include these parameters in a shortcut to the hpnci.cmd file or in a launch

file for the hpnci.sh file. For more information, see “Creating a Shortcut to hpnci.cmd” (page 47)

or “Presetting the Optional Launch Parameters” (page 51), respectively.

• On Windows, in the Command Prompt window, enter:

cd hpnci-installation-directory\Neoview Command Interface\bin

hpnci.cmd -h neo0101.mylab.mycorp.net:18650 -u dba1 -p xxxxxx

-dsn DataSourceName

• On Linux or UNIX, in the terminal window, enter:

cd hpnci-installation-directory/nci/bin

./hpnci.sh -h neo0101.mylab.mycorp.net:18650 -u dba1 -p xxxxxx

-dsn DataSourceName

The Neoview Command Interface launches and prompts you to enter an SQL statement or an

NCI command:

Welcome to the HP Neoview Command Interface 2.4

Connected to DataSource: Admin_Load_DataSource

SQL>

Running a Command When Launching NCI

To execute an SQL statement or an NCI command when launching the Neoview Command

Interface, use the -q or -sql command-line parameter. This parameter enables you to run a

single command on the command line without having to enter commands in NCI.

NOTE: You cannot specify this parameter at the same time as the -s or -script parameter.

When using -q or -sql, you must enclose the command in double quotes. The SQL terminator

is not required at the end of an SQL statement and is disallowed after an NCI command.

Although you can run any of the NCI commands with -q or -sql, the @, OBEY, and PRUN

commands are the most useful. For a list of supported SQL statements, see Appendix B (page 159).

Example of Running an SQL Statement With -q or -sql

Use -q or -sql with the CREATE SCHEMA statement to create a schema when launching NCI:

• On Windows, in the Command Prompt window, enter:

cd hpnci-installation-directory\Neoview Command Interface\bin

Logging In to the Database Platform 55