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

 

Chapter or Appendix

 

New or Changed Information

 

 

 

 

 

 

“Setting the Look and Feel of the

 

There is a new look and feel property value, BTEQ (to support Teradata). This

 

Neoview Script Interface” (page 35)

 

property affects the formatting of status messages. The look and feel property

 

 

 

 

value Oracle is no longer available, but is supported for backward compatibility.

 

 

 

 

For more information, see “Setting the Look and Feel of the Neoview Script

 

 

 

 

Interface” (page 35).

 

 

 

 

 

 

“Launching the Neoview Script

 

There is a new optional launch parameter -noconnect. For more information,

 

Interface” (page 41)

 

see“Launching Neoview Script Without Connecting to the Database” (page 49).

 

 

 

 

 

 

Appendix A: Neoview Script

 

This appendix describes these new interface commands:

 

Interface Commands

 

•

CONNECT

 

 

 

 

• RECONNECT

 

 

 

 

• SET MARKUP

 

 

 

 

•

SET COLSEP

 

 

 

 

•

SET HISTOPT

 

 

 

 

• SHOW COLSEP

 

 

 

 

• SHOW HISTOPT

 

 

 

 

• SHOW MARKUP

 

 

 

 

• SHOW PREPARED

 

 

 

 

This appendix also includes changes these existing interface commands:

 

 

 

 

• DISCONNECT

 

 

 

 

• ENV

 

 

 

 

• PRUN

 

 

 

 

•

SESSION

 

 

 

 

•

SET TIME

 

 

 

 

• SHOW TABLE

 

 

 

 

•

SHOW SESSION

Document Organization

 

 

 

 

 

 

 

 

 

 

Chapter 1: Introduction to

 

Introduces Neoview Script and describes its capabilities.

 

Neoview Script

 

 

 

 

 

 

 

 

 

Chapter 2: Installing Neoview

 

Describes how to install Neoview Script on the client workstation.

 

Script

 

 

 

 

 

 

 

 

 

Chapter 3: Launching the Neoview

 

Describes how to launch, log in to, and exit the Neoview Script interface on a

 

Script Interface

 

client workstation.

 

 

 

 

 

Chapter 4: Running Commands

 

Describes how to run commands interactively in the Neoview Script interface.

 

Interactively in the Neoview Script

 

 

 

 

 

Interface

 

 

 

 

 

 

 

 

 

Chapter 5: Running Scripts in the

 

Describes how to run script files in the Neoview Script interface.

 

Neoview Script Interface

 

 

 

 

 

 

 

 

 

 

Intended Audience

15