Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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...........................................
Résumé du contenu de la page N° 4
Presetting the Optional Launch Parameters....................................................................................45 Logging In to the Database Platform....................................................................................................45 Default Login...................................................................................................................................45 Login Parameters.......................................................................
Résumé du contenu de la page N° 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...................................................................................................
Résumé du contenu de la page N° 6
Examples..........................................................................................................................................84 DISCONNECT Command....................................................................................................................84 Syntax..............................................................................................................................................84 Considerations.................................................
Résumé du contenu de la page N° 7
Considerations...............................................................................................................................100 Example.........................................................................................................................................100 RUN Command..................................................................................................................................100 Syntax........................................................
Résumé du contenu de la page N° 8
Syntax.............................................................................................................................................114 Considerations...............................................................................................................................114 Examples........................................................................................................................................114 SHOW HISTOPT Command....................................
Résumé du contenu de la page N° 9
SHOW SQLTERMINATOR Command...............................................................................................124 Syntax.............................................................................................................................................124 Considerations...............................................................................................................................124 Example........................................................................
Résumé du contenu de la page N° 10
10
Résumé du contenu de la page N° 11
L is t o f F i gur e s 1-1 Neoview Script Within a Neoview Platform Network.................................................................21 11
Résumé du contenu de la page N° 12
12
Résumé du contenu de la page N° 13
L is t o f T a ble s 2-1 Locations of Neoview Script Software Files..................................................................................34 13
Résumé du contenu de la page N° 14
14
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 20
20