Summary of the content on the page No. 1
HP Neo v i e w S c r ipt Gui de
HP P ar t Numbe r : 5 44 5 3 0 -00 1
P u blished: Ma y 200 7
E diti o n: HP Neo v i e w R e lea s e 2 . 1
Summary of the content on the page No. 2
© Copyright 2007 Hewlett-Packard Development Company, L.P. Leg al 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. The only warranties for HP products and
Summary of the content on the page No. 3
T a ble o f C o n t e n ts A bo u t T his Doc ume n t.......................................................................................................15 Intended Audience................................................................................................................................15 New and Changed Information in This Edition...................................................................................15 Document Organization...........................................
Summary of the content on the page No. 4
Presetting the Optional Launch Parameters....................................................................................45 Logging In to the Database Platform....................................................................................................45 Default Login...................................................................................................................................45 Login Parameters.......................................................................
Summary of the content on the page No. 5
SPOOL log-file or LOG log-file Command................................................................................64 Using the CLEAR Option...........................................................................................................64 Logging Concurrent Neoview Script Sessions...........................................................................64 Stopping the Logging Process...................................................................................................
Summary of the content on the page No. 6
Examples..........................................................................................................................................84 DISCONNECT Command....................................................................................................................84 Syntax..............................................................................................................................................84 Considerations.................................................
Summary of the content on the page No. 7
Considerations...............................................................................................................................100 Example.........................................................................................................................................100 RUN Command..................................................................................................................................100 Syntax........................................................
Summary of the content on the page No. 8
Syntax.............................................................................................................................................114 Considerations...............................................................................................................................114 Examples........................................................................................................................................114 SHOW HISTOPT Command....................................
Summary of the content on the page No. 9
SHOW SQLTERMINATOR Command...............................................................................................124 Syntax.............................................................................................................................................124 Considerations...............................................................................................................................124 Example........................................................................
Summary of the content on the page No. 10
10
Summary of the content on the page No. 11
L is t o f F i gur e s 1-1 Neoview Script Within a Neoview Platform Network.................................................................21 11
Summary of the content on the page No. 12
12
Summary of the content on the page No. 13
L is t o f T a ble s 2-1 Locations of Neoview Script Software Files..................................................................................34 13
Summary of the content on the page No. 14
14
Summary of the content on the page No. 15
A bo u t T his Doc ume n t 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. In t e nded A udi e nce This manual is intended for database administrators and support personnel who are maintaining and monitoring a Neoview database. Ne w and C hanged Inf o r mati o
Summary of the content on the page No. 16
Chapter 6: Running Neoview Describes how to run Neoview Script from Perl or Python. Script From Perl or Python Appendix A: Neoview Script Provides syntax, considerations, and examples for Neoview Script interface Interface Commands commands. Appendix B: Supported SQL Lists the SQL statements that Neoview Script supports. Statements Appendix C: Connectivity Service Provides syntax, considerations, and examples for connectivity service commands. Commands No t ati o n C o n v e n ti o ns Ge ne r al
Summary of the content on the page No. 17
| Vertical Line A vertical line separates alternatives in a horizontal list that is enclosed in brackets or braces. For example: {expression | NULL} … Ellipsis An ellipsis immediately following a pair of brackets or braces indicates that you can repeat the enclosed sequence of syntax items any number of times. For example: ATTRIBUTE[S] attribute [, attribute]... {, sql-expression}... An ellipsis immediately following a single syntax item indicates that you can repeat that syntax item any number
Summary of the content on the page No. 18
Neo v i e w C u s t o me r L ibr ar y This manual is part of the Neoview customer library: • Administration Neoview Database Administrator’s Guide Information about how to load and manage the Neoview database by using the Neoview DB Admin and other tools. Neoview DB Admin Online Help Context-sensitive help topics that describe how to use the HP Neoview DB Admin management interface. Neoview Management Dashboard Client Information on using the Dashboard Client, including how to install Guide for
Summary of the content on the page No. 19
Neoview Hardwar e Installation and Support Installation and replacement procedures. Guide Neoview Management Dashboard Support Guide Information on managing and configuring Dashboard from the Dashboard Server and Client, including starting and running Dashboard, using Discrete Object Thresholds (DOTs), using Dashboard Command Interpreter commands, using the Entity Definition Language (EDL), and using Dashboard data definitions and record declarations. Neoview Migration and Upgrade Guide Procedur
Summary of the content on the page No. 20
20
