HP Neoview Script Guide
HP Part Number: 544530-001
Published: May 2007
Edition: HP Neoview Release 2.1
© Copyright 2007 Hewlett-Packard Development Company, L.P.
Legal 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 services are set forth in the express
warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP
shall not be liable for technical or editorial errors or omissions contained herein.
Export of the information contained in this publication may require authorization from the U.S. Department of Commerce.
Microsoft, Windows, and Windows NT are U.S. registered trademarks of Microsoft Corporation.
Intel, Pentium, and Celeron are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other
countries.
Java is a U.S. trademark of Sun Microsystems, Inc.
Motif, OSF/1, UNIX, X/Open, and the "X" device are registered trademarks, and IT DialTone and The Open Group are trademarks of The Open
Group in the U.S. and other countries.
Open Software Foundation, OSF, the OSF logo, OSF/1, OSF/Motif, and Motif are trademarks of the Open Software Foundation, Inc. OSF MAKES
NO WARRANTY OF ANY KIND WITH REGARD TO THE OSF MATERIAL PROVIDED HEREIN, INCLUDING, BUT NOT LIMITED TO, THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. OSF shall not be liable for errors contained
herein or for incidental consequential damages in connection with the furnishing, performance, or use of this material.
© 1990, 1991, 1992, 1993 Open Software Foundation, Inc. The OSF documentation and the OSF software to which it relates are derived in part
from materials supplied by the following:© 1987, 1988, 1989 Carnegie-Mellon University. © 1989, 1990, 1991 Digital Equipment Corporation. ©
1985, 1988, 1989, 1990 Encore Computer Corporation. © 1988 Free Software Foundation, Inc. © 1987, 1988, 1989, 1990, 1991 Hewlett-Packard
Company. © 1985, 1987, 1988, 1989, 1990, 1991, 1992 International Business Machines Corporation. © 1988, 1989 Massachusetts Institute of
Technology. © 1988, 1989, 1990 Mentat Inc. © 1988 Microsoft Corporation. © 1987, 1988, 1989, 1990, 1991, 1992 SecureWare, Inc. © 1990, 1991
Siemens Nixdorf Informationssysteme AG. © 1986, 1989, 1996, 1997 Sun Microsystems, Inc. © 1989, 1990, 1991 Transarc Corporation.OSF software
and documentation are based in part on the Fourth Berkeley Software Distribution under license from The Regents of the University of California.
OSF acknowledges the following individuals and institutions for their role in its development: Kenneth C.R.C. Arnold, Gregory S. Couch, Conrad
C. Huang, Ed James, Symmetric Computer Systems, Robert Elz. © 1980, 1981, 1982, 1983, 1985, 1986, 1987, 1988, 1989 Regents of the University
of California.
Table of Contents
About This Document.......................................................................................................15
Intended Audience................................................................................................................................15
New and Changed Information in This Edition...................................................................................15
Document Organization.......................................................................................................................15
Notation Conventions...........................................................................................................................16
General Syntax Notation.................................................................................................................16
Related Documentation........................................................................................................................17
Neoview Customer Library.............................................................................................................18
Neoview Support Library................................................................................................................18
Publishing History................................................................................................................................19
HP Encourages Your Comments..........................................................................................................19
1 Introduction to Neoview Script...................................................................................21
2 Installing Neoview Script.............................................................................................23
Preinstallation Procedures....................................................................................................................23
Installing and Verifying the Java Runtime Environment (JRE)......................................................23
Installing a Supported Java Version...........................................................................................23
Verifying the Java Version..........................................................................................................24
Setting the PATH to a Supported Java Version on Windows....................................................24
Setting the PATH to a Supported Java Version on Linux or UNIX............................................26
Installing and Verifying the Neoview JDBC Type 4 Driver............................................................26
Installing the JDBC Driver.........................................................................................................26
Verifying the JDBC Driver..........................................................................................................26
Installing Perl or Python..................................................................................................................27
Installation Procedures.........................................................................................................................27
Downloading the Installer...............................................................................................................27
Verifying the Version of the Installer File........................................................................................28
Running the Installer.......................................................................................................................28
Installer Wizard Steps................................................................................................................28
Launching the Installer Wizard............................................................................................28
Using the Installer Wizard....................................................................................................29
Command-Line Installation Steps..............................................................................................33
Postinstallation Procedures...................................................................................................................34
Verifying the Installed Software Files..............................................................................................34
Verifying the Installed Version of Neoview Script..........................................................................35
Setting the Look and Feel of the Neoview Script Interface.............................................................35
Supported Look-and-Feel Types................................................................................................36
Setting the Look and Feel at a Command-Line Prompt............................................................37
Setting the Look and Feel in the System Properties on Windows.............................................37
Setting the Look and Feel in the User Profile on Linux or UNIX..............................................39
Testing the Launch of Neoview Script............................................................................................39
3 Launching the Neoview Script Interface....................................................................41
Launching the Neoview Script Interface on Windows.........................................................................41
Creating a Shortcut to hpnvs.cmd...................................................................................................41
Launching the Neoview Script Interface on Linux or UNIX................................................................44
Setting the PATH of hpnvs.sh..........................................................................................................44
Table of Contents 3
Presetting the Optional Launch Parameters....................................................................................45
Logging In to the Database Platform....................................................................................................45
Default Login...................................................................................................................................45
Login Parameters.............................................................................................................................46
Using Optional Launch Parameters................................................................................................46
Logging In When Launching Neoview Script...........................................................................47
Running a Command When Launching Neoview Script..........................................................47
Example of Running an SQL Statement With -q or -sql.......................................................48
Example of Running a Neoview Script Interface Command With -q or -sql.......................48
Running a Script File When Launching Neoview Script...........................................................48
Example of a Script File........................................................................................................49
Example of Running a Script File With -s or -script.............................................................49
Launching Neoview Script Without Connecting to the Database.............................................49
Example of Launching Neoview Script File With -noconnect..............................................50
Exiting the Neoview Script Interface....................................................................................................50
4 Running Commands Interactively in the Neoview Script Interface.........................51
Neoview Script Interface......................................................................................................................51
Product Banner................................................................................................................................51
Interface Prompts............................................................................................................................51
Breaking the Command Line...........................................................................................................51
Case Sensitivity................................................................................................................................52
Using Neoview Script Interface Commands........................................................................................52
Showing the Session Attributes.......................................................................................................52
Setting and Showing the Idle Timeout Value for the Session.........................................................53
Customizing the Standard Prompt..................................................................................................53
SET PROMPT Command...........................................................................................................53
SET TIME Command.................................................................................................................53
Setting and Showing the SQL Terminator.......................................................................................54
Displaying the Elapsed Time...........................................................................................................54
Setting and Showing the Current Schema.......................................................................................55
Limiting the Result Set of a Query..................................................................................................55
Showing Information About SQL Database Objects.......................................................................55
Showing the Schemas.................................................................................................................56
Showing the Tables in a Schema................................................................................................56
Showing the Dependent Objects of a Table................................................................................56
Showing the Views in a Schema.................................................................................................57
Showing the Synonyms in a Schema.........................................................................................57
Displaying Executed Commands....................................................................................................58
Editing and Reexecuting a Command.............................................................................................58
Clearing the Interface Window.......................................................................................................58
Obtaining Help................................................................................................................................58
Running SQL Statements......................................................................................................................59
Executing an SQL Statement...........................................................................................................59
Repeating an SQL Statement...........................................................................................................59
Preparing and Executing SQL Statements......................................................................................60
Preparing an SQL Statement......................................................................................................60
Setting Parameters......................................................................................................................61
Displaying the Parameters of the Session..................................................................................61
Resetting the Parameters............................................................................................................61
Executing a Prepared SQL Statement........................................................................................62
Logging Output....................................................................................................................................63
Starting the Logging Process...........................................................................................................63
SPOOL ON or LOG ON Command...........................................................................................63
4 Table of Contents
SPOOL log-file or LOG log-file Command................................................................................64
Using the CLEAR Option...........................................................................................................64
Logging Concurrent Neoview Script Sessions...........................................................................64
Stopping the Logging Process.........................................................................................................64
Viewing the Contents of a Log File.................................................................................................64
5 Running Scripts in the Neoview Script Interface.......................................................67
Creating a Script File.............................................................................................................................67
Supported SQL Statements in Script Files.......................................................................................67
Permitted Neoview Script Interface Commands in Script Files......................................................67
Disallowed Interface Commands in Script Files........................................................................67
Comments........................................................................................................................................67
Section Headers...............................................................................................................................67
Example of a Script File...................................................................................................................68
Running a Script File.............................................................................................................................68
Logging Output....................................................................................................................................69
Running Scripts in Parallel...................................................................................................................69
6 Running Neoview Script From Perl or Python............................................................71
Setting the Login Environment Variables.............................................................................................71
Setting the Login Environment Variables on Windows..................................................................71
Setting Login Environment Variables on the Command Line...................................................71
Setting Login Environment Variables in the System Properties................................................72
Setting the Login Environment Variables on Linux or UNIX.........................................................73
Setting Login Environment Variables on the Command Line...................................................73
Setting Login Environment Variables in the User Profile..........................................................74
Perl and Python Wrapper Scripts.........................................................................................................74
Launching Neoview Script From the Perl or Python Command Line.................................................74
Perl and Python Commands on Windows......................................................................................75
Perl and Python Commands on Linux or UNIX.............................................................................75
Launching Neoview Script From a Perl or Python Program...............................................................76
Setting the Login Environment Variables........................................................................................76
Using SQL Statements in a Perl or Python Program.......................................................................76
Example of a Perl Program (example.pl)...................................................................................76
Example of a Python Program (example.py).............................................................................77
Running the Perl or Python Program..............................................................................................77
A Neoview Script Interface Commands........................................................................79
@ Command..........................................................................................................................................81
Syntax..............................................................................................................................................81
Considerations.................................................................................................................................82
Examples..........................................................................................................................................82
/ Command...........................................................................................................................................82
Syntax..............................................................................................................................................82
Considerations.................................................................................................................................82
Example...........................................................................................................................................82
CLEAR Command................................................................................................................................83
Syntax..............................................................................................................................................83
Considerations.................................................................................................................................83
Example...........................................................................................................................................83
CONNECT Command..........................................................................................................................83
Syntax..............................................................................................................................................83
Considerations.................................................................................................................................83
Table of Contents 5
Examples..........................................................................................................................................84
DISCONNECT Command....................................................................................................................84
Syntax..............................................................................................................................................84
Considerations.................................................................................................................................84
Examples..........................................................................................................................................84
ENV Command.....................................................................................................................................85
Syntax..............................................................................................................................................85
Considerations.................................................................................................................................85
Examples..........................................................................................................................................86
EXIT Command....................................................................................................................................86
Syntax..............................................................................................................................................86
Considerations.................................................................................................................................87
Examples..........................................................................................................................................87
FC Command........................................................................................................................................87
Syntax..............................................................................................................................................87
Considerations.................................................................................................................................88
Examples..........................................................................................................................................88
HELP Command...................................................................................................................................90
Syntax..............................................................................................................................................90
Considerations.................................................................................................................................90
Examples..........................................................................................................................................90
HISTORY Command............................................................................................................................90
Syntax..............................................................................................................................................91
Considerations.................................................................................................................................91
Example...........................................................................................................................................91
LOG Command.....................................................................................................................................91
Syntax..............................................................................................................................................91
Considerations.................................................................................................................................92
Examples..........................................................................................................................................92
MODE Command.................................................................................................................................92
Syntax..............................................................................................................................................92
Considerations.................................................................................................................................93
Examples..........................................................................................................................................93
OBEY Command...................................................................................................................................93
Syntax..............................................................................................................................................93
Considerations.................................................................................................................................94
Examples..........................................................................................................................................94
PRUN Command..................................................................................................................................95
Syntax..............................................................................................................................................95
Considerations.................................................................................................................................96
Example...........................................................................................................................................96
QUIT Command...................................................................................................................................97
Syntax..............................................................................................................................................97
Considerations.................................................................................................................................97
Examples..........................................................................................................................................97
RECONNECT Command.....................................................................................................................98
Syntax..............................................................................................................................................98
Considerations.................................................................................................................................98
Examples..........................................................................................................................................98
REPEAT Command...............................................................................................................................98
Syntax..............................................................................................................................................98
Considerations.................................................................................................................................99
Examples..........................................................................................................................................99
RESET PARAM Command...................................................................................................................99
Syntax.............................................................................................................................................100
6 Table of Contents
Considerations...............................................................................................................................100
Example.........................................................................................................................................100
RUN Command..................................................................................................................................100
Syntax.............................................................................................................................................100
Considerations...............................................................................................................................100
Example.........................................................................................................................................100
SAVEHIST Command.........................................................................................................................101
Syntax.............................................................................................................................................101
Considerations...............................................................................................................................101
Examples........................................................................................................................................101
SET COLSEP Command.....................................................................................................................101
Syntax.............................................................................................................................................102
Considerations...............................................................................................................................102
Examples........................................................................................................................................102
SET HISTOPT Command....................................................................................................................102
Syntax.............................................................................................................................................102
Considerations...............................................................................................................................102
Examples........................................................................................................................................102
SET IDLETIMEOUT Command..........................................................................................................103
Syntax.............................................................................................................................................103
Considerations...............................................................................................................................104
Examples........................................................................................................................................104
SET MARKUP Command...................................................................................................................104
Syntax.............................................................................................................................................104
Considerations...............................................................................................................................104
Examples........................................................................................................................................104
SET LIST_COUNT Command............................................................................................................106
Syntax.............................................................................................................................................106
Considerations...............................................................................................................................106
Examples........................................................................................................................................107
SET PARAM Command......................................................................................................................107
Syntax.............................................................................................................................................108
Considerations...............................................................................................................................108
Examples........................................................................................................................................108
SET PROMPT Command....................................................................................................................109
Syntax.............................................................................................................................................109
Considerations...............................................................................................................................109
Examples........................................................................................................................................109
SET SQLPROMPT Command.............................................................................................................110
Syntax.............................................................................................................................................110
Considerations...............................................................................................................................111
Examples........................................................................................................................................111
SET SQLTERMINATOR Command....................................................................................................112
Syntax.............................................................................................................................................112
Considerations...............................................................................................................................112
Examples........................................................................................................................................112
SET TIME Command..........................................................................................................................112
Syntax.............................................................................................................................................112
Considerations...............................................................................................................................112
Examples........................................................................................................................................113
SET TIMING Command.....................................................................................................................113
Syntax.............................................................................................................................................113
Considerations...............................................................................................................................113
Examples........................................................................................................................................113
SHOW COLSEP Command................................................................................................................113
Table of Contents 7
Syntax.............................................................................................................................................114
Considerations...............................................................................................................................114
Examples........................................................................................................................................114
SHOW HISTOPT Command..............................................................................................................114
Syntax.............................................................................................................................................114
Considerations...............................................................................................................................114
Examples........................................................................................................................................114
SHOW IDLETIMEOUT Command.....................................................................................................114
Syntax.............................................................................................................................................114
Considerations...............................................................................................................................114
Examples........................................................................................................................................115
SHOW LIST_COUNT Command.......................................................................................................115
Syntax.............................................................................................................................................115
Considerations...............................................................................................................................115
Examples........................................................................................................................................115
SHOW MARKUP Command..............................................................................................................115
Syntax.............................................................................................................................................115
Considerations...............................................................................................................................115
Examples........................................................................................................................................116
SHOW MODE Command...................................................................................................................116
Syntax.............................................................................................................................................116
Considerations...............................................................................................................................116
Example.........................................................................................................................................116
SHOW MVGROUPS Command.........................................................................................................116
Syntax.............................................................................................................................................116
Considerations...............................................................................................................................117
Examples........................................................................................................................................117
SHOW MVS Command......................................................................................................................117
Syntax.............................................................................................................................................117
Considerations...............................................................................................................................118
Examples........................................................................................................................................118
SHOW PARAM Command.................................................................................................................118
Syntax.............................................................................................................................................119
Considerations...............................................................................................................................119
Example.........................................................................................................................................119
SHOW PREPARED Command...........................................................................................................119
Syntax.............................................................................................................................................119
Considerations...............................................................................................................................119
Examples........................................................................................................................................120
SHOW SCHEMA Command..............................................................................................................120
Syntax.............................................................................................................................................120
Considerations...............................................................................................................................120
Example.........................................................................................................................................120
SHOW SCHEMAS Command............................................................................................................120
Syntax.............................................................................................................................................120
Considerations...............................................................................................................................121
Examples........................................................................................................................................121
SHOW SESSION Command...............................................................................................................122
Syntax.............................................................................................................................................122
Considerations...............................................................................................................................122
Examples........................................................................................................................................123
SHOW SQLPROMPT Command........................................................................................................123
Syntax.............................................................................................................................................123
Considerations...............................................................................................................................124
Example.........................................................................................................................................124
8 Table of Contents
SHOW SQLTERMINATOR Command...............................................................................................124
Syntax.............................................................................................................................................124
Considerations...............................................................................................................................124
Example.........................................................................................................................................124
SHOW SYNONYMS Command.........................................................................................................124
Syntax.............................................................................................................................................124
Considerations...............................................................................................................................125
Examples........................................................................................................................................125
SHOW TABLE Command...................................................................................................................125
Syntax.............................................................................................................................................126
Considerations...............................................................................................................................126
Examples........................................................................................................................................126
SHOW TABLES Command.................................................................................................................127
Syntax.............................................................................................................................................127
Considerations...............................................................................................................................128
Examples........................................................................................................................................128
SHOW TIME Command.....................................................................................................................128
Syntax.............................................................................................................................................129
Considerations...............................................................................................................................129
Example.........................................................................................................................................129
SHOW TIMING Command................................................................................................................129
Syntax.............................................................................................................................................129
Considerations...............................................................................................................................129
Example.........................................................................................................................................129
SHOW VIEWS Command...................................................................................................................129
Syntax.............................................................................................................................................129
Considerations...............................................................................................................................130
Examples........................................................................................................................................130
SPOOL Command...............................................................................................................................130
Syntax.............................................................................................................................................130
Considerations...............................................................................................................................131
Examples........................................................................................................................................131
VERSION Command..........................................................................................................................131
Syntax.............................................................................................................................................131
Considerations...............................................................................................................................132
Example.........................................................................................................................................132
B Supported SQL Statements.......................................................................................133
C Connectivity Service Commands.............................................................................135
INFO DS Command............................................................................................................................135
Syntax.............................................................................................................................................135
Considerations...............................................................................................................................135
Example.........................................................................................................................................135
Index...............................................................................................................................137
Table of Contents 9
10
12
14
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
There is a new look and feel property value, BTEQ (to support Teradata). This
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).
“Setting the Look and Feel of the
Neoview Script Interface” (page 35)
There is a new optional launch parameter -noconnect. For more information,
see“Launching Neoview Script Without Connecting to the Database” (page 49).
“Launching the Neoview Script
Interface” (page 41)
This appendix describes these new 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
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
Describes how to run Neoview Script from Perl or Python.Chapter 6: Running Neoview
Script From Perl or Python
Provides syntax, considerations, and examples for Neoview Script interface
commands.
Appendix A: Neoview Script
Interface Commands
Lists the SQL statements that Neoview Script supports.Appendix B: Supported SQL
Statements
Provides syntax, considerations, and examples for connectivity service commands.Appendix C: Connectivity Service
Commands
Notation Conventions
General Syntax Notation
This list summarizes the notation conventions for syntax presentation in this manual.
UPPERCASE LETTERS Uppercase letters indicate keywords and reserved words. Type these
items exactly as shown. Items not enclosed in brackets are required.
For example:
SELECT
Italic Letters
Italic letters, regardless of font, indicate variable items that you
supply. Items not enclosed in brackets are required. For example:
file-name
Computer Type
Computer type letters within text indicate case-sensitive keywords
and reserved words. Type these items exactly as shown. Items not
enclosed in brackets are required. For example:
myfile.sh
[ ] Brackets Brackets enclose optional syntax items. For example:
DATETIME [start-field TO] end-field
A group of items enclosed in brackets is a list from which you can
choose one item or none. The items in the list can be arranged either
vertically, with aligned brackets on each side of the list, or
horizontally, enclosed in a pair of brackets and separated by vertical
lines. For example:
DROP SCHEMA schema [CASCADE]
[RESTRICT]
DROP SCHEMA schema [ CASCADE | RESTRICT ]
{ } Braces Braces enclose required syntax items. For example:
FROM { grantee[, grantee]...}
A group of items enclosed in braces is a list from which you are
required to choose one item. The items in the list can be arranged
either vertically, with aligned braces on each side of the list, or
horizontally, enclosed in a pair of braces and separated by vertical
lines. For example:
INTERVAL { start-field TO end-field }
{ single-field }
INTERVAL { start-field TO end-field | single-field }
16 About This Document
| 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 of times. For example:
expression-n…
Punctuation Parentheses, commas, semicolons, and other symbols not previously
described must be typed as shown. For example:
DAY (datetime-expression)
@script-file
Quotation marks around a symbol such as a bracket or brace indicate
the symbol is a required character that you must type as shown. For
example:
"{" module-name [, module-name]... "}"
Item Spacing Spaces shown between items are required unless one of the items is
a punctuation symbol such as a parenthesis or a comma. For example:
DAY (datetime-expression)
DAY(datetime-expression)
If there is no space between two items, spaces are not permitted. In
this example, no spaces are permitted between the period and any
other items:
myfile.sh
Line Spacing If the syntax of a command is too long to fit on a single line, each
continuation line is indented three spaces and is separated from the
preceding line by a blank line. This spacing distinguishes items in a
continuation line from items in a vertical list of selections. For
example:
match-value [NOT] LIKE pattern
[ESCAPE esc-char-expression]
Related Documentation
The HP Neoview Library consists of:
• “Neoview Customer Library”
• “Neoview Support Library” (page 18)
Related Documentation 17
Neoview Customer Library
This manual is part of the Neoview customer library:
• Administration
Information about how to load and manage the Neoview database
by using the Neoview DB Admin and other tools.
Neoview Database Administrator’s Guide
Context-sensitive help topics that describe how to use the HP
Neoview DB Admin management interface.
Neoview DB Admin Online Help
Information on using the Dashboard Client, including how to install
the Client, start and configure the Client Server Gateway (CSG), use
the Client windows and property sheets, interpret entity screen
information, and use Command and Control to manage queries from
the Client.
Neoview Management Dashboard Client
Guide for Database Administrators
Site-planning information and basic hardware information.Neoview Owner’s Manual
Information about using the HP Neoview Script command-line
interface to run SQL statements interactively or from script files.
Neoview Script Guide
Command-line help that describes the interface commands supported
in the current operating mode of Neoview Script.
Neoview Script Online Help
• Reference
Reference information about the syntax of SQL statements,
functions, and other SQL language elements supported by the
Neoview database software.
Neoview SQL Reference Manual
Cause, effect, and recovery information for error messages.Neoview Messages Manual
Information about known problems that are visible to customers.README for Neoview Platform for
Release 2.1
• Connectivity
Reference information about the HP Neoview JDBC Type 4 Driver
API.
Neoview JDBC Type 4 Driver API Reference
Information about using the HP Neoview JDBC Type 4 driver,
which provides Java applications on client workstations access a
Neoview database.
Neoview JDBC Type 4 Driver Programmer’s
Reference
Information about using HP Neoview ODBC drivers on a client
workstation to access a Neoview database.
Neoview ODBC Drivers Manual
Context-sensitive help topics that describe how to use the ODBC
client interface.
ODBC Client Administrator Online Help
— README for HP JDBC Type 4 Driver
— README for HP ODBC Driver for Windows
— README for HP ODBC Driver for Linux and HP-UX
— README for HP Neoview Script
README files
Neoview Support Library
Reference information for using the boot software.Boot Application Online Help
Procedures and reference information that are unique to the Neoview
database software or not documented in other HP manuals.
Neoview Database Support Guide
18 About This Document
Installation and replacement procedures.Neoview Hardware Installation and 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 Management Dashboard Support Guide
Procedures for adding hardware, installing RVUs and updating other
software and firmware.
Neoview Migration and Upgrade Guide
Guidelines for troubleshooting ODBC and JDBC connectivity to an
HP Neoview data warehousing platform.
Neoview ODBC and JDBC Troubleshooting
Guide
Quick guide to schemas, tables, columns, and data types for Version
2000 Neoview SQL metadata.
Neoview SQL Metadata Quick Reference
Information about installing and configuring applications on the
Neoview system console
Neoview System Console Installer Guide
Information related to query execution plans and how to affect the
query performance of Neoview databases
Neoview Query Support Guide
Information about installing and maintaining the Neoview Virtual
TapeServer (VTS).
Neoview Virtual TapeServer Installation and
Support Guide
Information about using Neoview Workload Management Services
(NWMS) to manage workload and resources on a Neoview data
warehousing platform.
Neoview Workload Management Services Guide
Publishing History
Publication DateProduct VersionPart Number
August 2006HP Neoview Release 1.0542714-003
October 2006HP Neoview Release 1.1543708-001
November 2006HP Neoview Release 1.2543707-001
March 2007HP Neoview Release 2.0544356-001
May 2007HP Neoview Release 2.1544530-001
HP Encourages Your Comments
HP encourages your comments concerning this document. We are committed to providing
documentation that meets your needs. Send any errors found, suggestions for improvement, or
compliments to:
Include the document title, part number, and any comment, error found, or suggestion for
improvement you have concerning this document.
Publishing History 19
20
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
-
1
-
2
-
3
-
4
-
5
-
6
-
7
-
8
-
9
-
10
-
11
-
12
-
13
-
14
-
15
-
16
-
17
-
18
-
19
-
20
-
21
-
22
-
23
-
24
-
25
-
26
-
27
-
28
-
29
-
30
-
31
-
32
-
33
-
34
-
35
-
36
-
37
-
38
-
39
-
40
-
41
-
42
-
43
-
44
-
45
-
46
-
47
-
48
-
49
-
50
-
51
-
52
-
53
-
54
-
55
-
56
-
57
-
58
-
59
-
60
-
61
-
62
-
63
-
64
-
65
-
66
-
67
-
68
-
69
-
70
-
71
-
72
-
73
-
74
-
75
-
76
-
77
-
78
-
79
-
80
-
81
-
82
-
83
-
84
-
85
-
86
-
87
-
88
-
89
-
90
-
91
-
92
-
93
-
94
-
95
-
96
-
97
-
98
-
99
-
100
-
101
-
102
-
103
-
104
-
105
-
106
-
107
-
108
-
109
-
110
-
111
-
112
-
113
-
114
-
115
-
116
-
117
-
118
-
119
-
120
-
121
-
122
-
123
-
124
-
125
-
126
-
127
-
128
-
129
-
130
-
131
-
132
-
133
-
134
-
135
-
136
-
137
-
138
-
139
-
140
-
141
-
142
Ask a question and I''ll find the answer in the document
Finding information in a document is now easier with AI
Related papers
Other documents
-
LifeCore Fitness LC-1060UB User manual
-
LifeCore Fitness LC-1060RB User manual
-
LifeCore Fitness LC-960RB User manual
-
IBM DB2 User manual
-
Wiley 978-0-7645-8894-5 Datasheet
-
Wiley 978-0-7645-9654-4 Datasheet
-
VMware vFabric Postgres 9.3.2 User guide
-
OpenLink Software Server 4.5 User manual
-
Novell Audit 2.0.2 Administration Guide
-
