README for the HP Neoview Command Interface (NCI) HP Part Number: 546554-001 Published: October 2008 Edition: HP Neoview Release 2.3 Service Pack 2 (Client Update 1 for Release 2.
© Copyright 2008 Hewlett-Packard Development Company, L.P. Legal Notice Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Table of Contents Checking Version Compatibility............................................................................................................5 Getting the Version of an Installed Client Product...........................................................................5 Installation for Neoview Release 2.3......................................................................................................6 Installation Package...................................................................
Checking Version Compatibility Before installing the client product, check the compatibility of the product with the Neoview platform. Neoview Release of Client Product the Client Product Name Compatible versions of the Neoview platform 2.3 Neoview Release 2.3 and later versions NCI NOTE: In previous releases, Neoview Command Interface (NCI) was called Neoview Script. To avoid client product and Neoview platform version incompatibility, see the Neoview Command Interface Guide at http://docs.hp.
2. Enter this command to return version information: java -jar hpnci.jar The command displays this version information: T0774_N26_AAH(SP2)__HP_NCI___- is the date, where
- is the day, is the month, and is the year (for example, 01JAN08). The second part is __
- where is the year, is the month, and
- is the day (for example, 2008_01_15).
File contained in the installer file (by default, these files are installed in the /samples directory): • • • • • • • • • • • README arrayDML.pl arrayIQ.pl sample.pl sample.sql sample-beta.pl sampleTables.pl sampleTables.py sampleDDL.py sampleDML.py sample-deprecated.py Installation Requirements You must have Sun's Java Runtime Environment (JRE) version of 1.5, 1.4.2 or later installed on the client workstation.
2. On the client workstation, start a Web browser and navigate to the download site: http://www.software.hp.com 3. 5. Enter Neoview Command Interface in the search box in the upper right corner of the Software Depot home page. Click the HP Neoview Command Interface link that appears in the search results and download the HP Neoview Command Interface. The installer jar file hpnciInstaller.jar is available within the ZIP file hpnci.zip: 6. . Unzip the hpnci.
1. Change to the directory where you downloaded the NCI installer file: cd installer-directory installer-directory is the directory where you downloaded the installer. 2. Enter this command to return version information: java -jar hpnciInstaller.jar v For example: C:\>cd download C:\download>java -jar hpnciInstaller.
1. Click Standard Installation to start the Installer Wizard. The Installer Wizard guides you through installing both the core NCI components and the optional open source extensions. For a quick installation of the core NCI files, click Core Components. If you have already installed the core NCI files, but want to install only the open source extensions, click on Optional Components. 2.
3. To locate the JDBC driver JAR file, click Browse next to HP Neoview JDBC Type 4 Driver JAR file: 4. Select the lib folder of the JDBC driver, and then click Open: Installation for Neoview Release 2.
5. Select hpt4jdbc.
6. 7. 8. To install in the default location, proceed to Step 9. To install in a user preferred location, proceed to Step 7. To find an installation location for NCI, click Browse next to HP Neoview Command Interface installation directory: Select the folder where you want to install NCI so that the directory path appears in the File Name box, and then click Select: Installation for Neoview Release 2.
The Installer Wizard displays the directory where NCI is installed. 9. 14 Click Next to review the open source disclaimer.
10. If you agree to the terms and conditions, click the checkbox and click Next. The Installer Wizard dialog box appears, showing which components are available for you to download and install: 11. Select the optional components to be downloaded and installed. Each optional component is installed if the component box is checked. Select the proxy information as necessary to download the open source extensions.
13. Click Detect Proxy Server(s) to start this process. If NCI detects one or more proxy servers, they are located in a drop-down menu next to the Detect Proxy Server(s) button. 14. Click Install to start the installation. After the core NCI files are installed, the Installation Status dialog box appears indicating how many files were extracted to the installation directory: 15. After the core NCI files are installed, the installer attempts to download and install the components.
After the core NCI files are installed, the Installer Wizard completes. Installation for Neoview Release 2.
16. Click Exit. Command-Line Installation Steps 1. At a command prompt, change to the directory where you downloaded the installer: cd installer-directory installer-directory is the directory where you downloaded the installer. 2. Before launching the command-line installer, see the command options below: java -jar hpnciInstaller.
The command-line installer starts and prompts you to enter the type of installation. For a Standard Installation, type Y and then click Enter. To install the Optional Components, type N and then click Enter for the optional components only (proceed to Step 6 for optional components): NOTE: value. 4. All items in square brackets are default values. Press Enter to accept the default Enter the full directory path and file name of the JDBC driver JAR file, hpt4jdbc.
Use a proxy server? [N]: If you do not require a proxy server, proceed to Step 8. 8. NCI can attempt to detect your proxy settings. If proxy servers are found they are displayed: Use a proxy server? [Y]: Y Attempt to auto-detect proxy server(s)? [Y]: N Enter the proxy server (do not include the port): myproxyserver.com Enter the proxy port: 8080 9. The install prompts you to indicate which optional components you wish to download and install. It also allows you to change the download URL.
For information about how to install, verify, and use NCI, see the Neoview Command Interface Guide. For information about setting up the client, such as choosing the look and feel of the interface or presetting launch parameters, see the Neoview Command Interface Guide. Using Conditional Statements NCI now supports conditional statements. In addition, the EXIT command has been enhanced. Note: These commands do not appear in the NCI Guide for R2.3, but will be included in a follow on release.
Syntax: IF { condition } THEN { action } { SQLTERMINATOR } The condition parameter is a Boolean statement structured as follows: condition { variable-name | value } { operator } { variable-name | value } variable-name { LASTERROR | RECCOUNT | ACTIVITYCOUNT | ERRORCODE | [%] any ENV variable | any SQL parameter } value { any-integer | quoted-string } quoted-string “any non-quote character” [\] is the optional escape character operator The following is a list of valid operators and their meanings == | = equal
SQL> LABEL insertBob SQL> INSERT INTO Employees(SSN, FName, LName) VALUES(123456789, 'Bob', 'Smith'); SQL> EXIT SHOW ACTIVITYCOUNT ACTIVITYCOUNT is an alias for RECCOUNT. For more information, see SHOW RECCOUNT. Example: SHOW ACTIVITYCOUNT SHOW ERRORCODE ERRORCODE is an alias for LASTERROR. For more information, see SHOW LASTERROR. Example: SHOW ERRORCODE EXIT The EXIT command disconnects from and exits NCI. EXIT can return a status code. If no status code is specified, zero is returned by default.
