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

About This Document
This guide describes how to use the Neoview Command Interface (NCI) on a client workstation
to manage a database on a Neoview data warehousing platform. NCI enables you to perform
daily administrative tasks by running SQL statements interactively or from script files.
Intended Audience
This guide is intended for database administrators and support personnel who are maintaining
and monitoring a Neoview database.
Document Organization
Introduces NCI and describes its capabilities.Chapter 1: Introduction to NCI
Describes how to install NCI on the client workstation.Chapter 2: Installing NCI
Describes how to launch, log in to, and exit the NCI on a client workstation.Chapter 3: Launching NCI
Describes how to run commands interactively in the NCI.Chapter 4: Running Commands
Interactively in the NCI
Describes how to run script files in the NCI.Chapter 5: Running Scripts in NCI
Describes how to run NCI from Perl or Python.Chapter 6: Running NCI From Perl
or Python
Provides syntax, considerations, and examples for NCI commands.Appendix A: NCI Commands
Lists the SQL statements that NCI supports.Appendix B: Supported SQL
Statements
Provides syntax, considerations, and examples for connectivity service commands.Appendix C: Connectivity Service
Commands
Provides a reference to the Neoview Workload Management Services Guide for the
Neoview service commands.
Appendix D: Neoview Service
(NS) Commands
New and Changed Information in This Edition
This guide designates new and changed material using change bars in the right margin:
• Newly added content has a green change bar.
• Changed content has an orange change bar.
New or Changed InformationChapter or Appendix
In text and examples, changed Release 2.3 references to Release 2.4, as needed.
Updated version procedure information for NCI and the JDBC Type 4 driver,
as needed.
All
Updated “Related Documentation” (page 16).About This Document
Updated Figure 1-1 (page 19).Chapter 1: Introduction to NCI
Updated some dialog boxes under “Installer Wizard Steps” (page 27).
Documented multisession support for Perl scripts and updated the file names
in Table 2-1 (page 39).
Added “Verifying Code-Signed Files” (page 40).
Restored a missing dialog box in “Setting the Look and Feel in the System
Properties on Windows” (page 42).
Updated the launch dialog box in “Testing the Launch of NCI” (page 46).
Chapter 2: Installing NCI
Added a note about schema names that begin with HP_, which are reserved for
use by HP.
Chapter 3: Launching NCI
Intended Audience 13