Neoview Script Guide (R2.2)

About This Document
This manual describes how to use the Neoview Script command-line interface on a client
workstation to manage a database on a Neoview data warehousing platform. Neoview Script
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
Added support for JRE 1.5. For more information, see “Installing and Verifying
the Java Runtime Environment (JRE)” (page 23).
Chapter 2: Installing Neoview
Script
There is a new optional launch parameter -version for the command line
option. For more information, see“Running Neoview Script With -version”
(page 54).
The Welcome banner is now displayed first, prior to login prompts. For more
information, see“Default Login” (page 47).
A maximum of three retries are available before a session terminates. For more
information, see“Default Login” (page 47).
Chapter 3: Launching the Neoview
Script Interface
A new section has been added that describes how to execute the CREATE
TRIGGER statement, see“Executing CREATE TRIGGER Statements” (page 67).
Chapter 4: Running Commands
Interactively in the Neoview Script
Interface
Added support for Stored Procedures in Java, For more information, see the
“SHOW PROCEDURES Command” (page 126).
This appendix describes these new interface commands:
• LOCALHOST
• ONLINEDBDUMP
• RESET LASTERROR
• SHOW LASTERROR
• SHOW PROCEDURES
This appendix also includes changes to the existing interface commands:
• SET MARKUP
• VERSION
Appendix A: Neoview Script
Interface Commands
Document Organization
Introduces Neoview Script and describes its capabilities.Chapter 1: Introduction to
Neoview Script
Describes how to install Neoview Script on the client workstation.Chapter 2: Installing Neoview
Script
Describes how to launch, log in to, and exit the Neoview Script interface on a
client workstation.
Chapter 3: Launching the Neoview
Script Interface
Describes how to run commands interactively in the Neoview Script interface.Chapter 4: Running Commands
Interactively in the Neoview Script
Interface
Describes how to run script files in the Neoview Script interface.Chapter 5: Running Scripts in the
Neoview Script Interface
Intended Audience 15