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

About This Document
This manual 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 manual is intended for database administrators and support personnel who are maintaining
and monitoring a Neoview database.
New and Changed Information in This Edition
New or Changed InformationChapter or Appendix
At Neoview Release 2.3, the Neoview Script product name has been changed to
the Neoview Command Interface (NCI). All references and directory names
have been changed to reflect the new product name NCI. The name change
applies to both the NCI Client (T0774) and the NCI Server (T0806).
Chapter 1: Introduction to NCI
The location of the installer jar file (hpnciInstaller.jar) has changed. The
file now resides within the ZIP file hpnci.zip. For more information, see
“Downloading the Installer” (page 27).
A new _JAVA_OPTIONS property (-Dhpnci.enableTrace) has been added
that enables/disables stacktrace on the console. For more information, see “Setting
the Trace Option” (page 46).
New samples for Perl and Python are available in the samples directory. For
more information, see “Verifying the Installed Software Files” (page 41).
Chapter 2: Installing NCI
There is a new optional launch parameter -help for the command line option.
For more information, see “Running NCI With -help” (page 60).
Chapter 3: Launching NCI
This appendix describes these new interface commands:
• GET STATISTICS
• SET STATISTICS
• SHOW STATISTICS
• RESET LASTERROR
• SHOW RECCOUNT
• Added support for the WMS commands. You can now issue these commands
in SQL mode. For more information on these commands, see the Neoview
Workload Management Services Guide.
• Added support for the ALLOW, DENY, and SHOW ACCESS commands.
These commands grant and revoke read access for memory dumpfiles to
super.services (HP support personnel), which they can use to diagnose a
problem. For more information, see the “ALLOW Command”
(page 93),“DENY Command” (page 94), and “SHOW ACCESS Command”
(page 131).
This appendix also includes changes to the existing NCI interface commands:
• The PRUN log file now displays the log end time.
• Additional options are available for the LOG or SPOOL commands. For more
information, see the “LOG Command” (page 104) and “SPOOL Command”
(page 151).
• Support for the wild-card characters (*) and (?) for the OBEY command.
• Support for (?) and (*) in wild-card patterns for all SHOW commands. This
is in addition to the existing SQL wildcard support (% and _ which maps to
* and ?, respectively).
• If the TIMING attribute is set to ON, the elapsed time is displayed for these
commands: PRUN, LOCALHOST, and SHOW commands. For more
information, see the related command.
• Consistent error formatting is now displayed for HTML and XML markup.
For more information, see the “SET MARKUP Command” (page 121).
Appendix A: NCI Commands
Intended Audience 15