ملخص المحتوى في الصفحة رقم 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
ملخص المحتوى في الصفحة رقم 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
ملخص المحتوى في الصفحة رقم 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...........................................
ملخص المحتوى في الصفحة رقم 4
Presetting the Optional Launch Parameters....................................................................................45 Logging In to the Database Platform....................................................................................................45 Default Login...................................................................................................................................45 Login Parameters.......................................................................
ملخص المحتوى في الصفحة رقم 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...................................................................................................
ملخص المحتوى في الصفحة رقم 6
Examples..........................................................................................................................................84 DISCONNECT Command....................................................................................................................84 Syntax..............................................................................................................................................84 Considerations.................................................
ملخص المحتوى في الصفحة رقم 7
Considerations...............................................................................................................................100 Example.........................................................................................................................................100 RUN Command..................................................................................................................................100 Syntax........................................................
ملخص المحتوى في الصفحة رقم 8
Syntax.............................................................................................................................................114 Considerations...............................................................................................................................114 Examples........................................................................................................................................114 SHOW HISTOPT Command....................................
ملخص المحتوى في الصفحة رقم 9
SHOW SQLTERMINATOR Command...............................................................................................124 Syntax.............................................................................................................................................124 Considerations...............................................................................................................................124 Example........................................................................
ملخص المحتوى في الصفحة رقم 10
10
ملخص المحتوى في الصفحة رقم 11
L is t o f F i gur e s 1-1 Neoview Script Within a Neoview Platform Network.................................................................21 11
ملخص المحتوى في الصفحة رقم 12
12
ملخص المحتوى في الصفحة رقم 13
L is t o f T a ble s 2-1 Locations of Neoview Script Software Files..................................................................................34 13
ملخص المحتوى في الصفحة رقم 14
14
ملخص المحتوى في الصفحة رقم 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
ملخص المحتوى في الصفحة رقم 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
ملخص المحتوى في الصفحة رقم 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
ملخص المحتوى في الصفحة رقم 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
ملخص المحتوى في الصفحة رقم 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
ملخص المحتوى في الصفحة رقم 20
20
