HP NEOVIEW 544530-001 User Manual
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 computersoftware. 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 informationcontained hereinis subject to change without notice. Theonly warranties forHP productsand 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 NixdorfInformationssysteme AG. © 1986, 1989,1996, 1997Sun Microsystems, Inc. © 1989,1990, 1991Transarc Corporation.OSFsoftware
and documentationare basedin parton the Fourth Berkeley SoftwareDistribution underlicense from The Regents of the Universityof California.
OSF acknowledgesthe followingindividuals 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
List of Figures
1-1 Neoview Script Within a Neoview Platform Network.................................................................21
11
12
List of Tables
2-1 Locations of Neoview Script Software Files..................................................................................34
13
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
“Setting the Look and Feel of the
Neoview Script Interface” (page 35)
“Launching the Neoview Script
Interface” (page 41)
Appendix A: Neoview Script
Interface Commands
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, butis supported for backwardcompatibility.
For more information, see “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).
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
Document Organization
Neoview Script
Script
Chapter 3:Launching theNeoview
Script Interface
Interactively inthe Neoview Script
Interface
Neoview Script Interface
Introduces Neoview Script and describes its capabilities.Chapter 1: Introduction to
Describes how to install Neoview Script on the client workstation.Chapter 2: Installing Neoview
Describes how to launch, log in to, and exit the Neoview Script interface on a
client workstation.
Describes how to run commands interactively in the Neoview Script interface.Chapter 4: Running Commands
Describes how to run script files in the Neoview Script interface.Chapter 5: Running Scripts in the
Intended Audience 15
Script From Perl or Python
Appendix A: Neoview Script
Interface Commands
Statements
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
Describes how to run Neoview Script from Perl or Python.Chapter 6: Running Neoview
Provides syntax, considerations, and examples for Neoview Script interface
commands.
Lists the SQL statements that Neoview Script supports.Appendix B: Supported SQL
Provides syntax,considerations, and examples for connectivity service commands.Appendix C: Connectivity Service
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:
16 About This Document
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 }
| 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 sequenceof syntax items anynumber
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
Neoview Database Administrator’s Guide
Neoview DB Admin Online Help
Neoview Management Dashboard Client
Guide for Database Administrators
Neoview Script Guide
Neoview Script Online Help
• Reference
Neoview SQL Reference Manual
Information about how to load and manage the Neoview database
by using the Neoview DB Admin and other tools.
Context-sensitive help topics that describe how to use the HP
Neoview DB Admin management interface.
Information on using the Dashboard Client, includinghow to install
the Client, start and configure the Client Server Gateway (CSG), use
the Client windows and property sheets, interpret entity screen
information, anduse Commandand Control to manage queries from
the Client.
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.
Command-line helpthat describesthe interfacecommands supported
in the current operating mode of Neoview Script.
Reference information about the syntax of SQL statements,
functions, and other SQL language elements supported by the
Neoview database software.
Cause, effect, and recovery information for error messages.Neoview Messages Manual
Release 2.1
• Connectivity
Neoview JDBC Type 4 Driver API Reference
Neoview JDBC Type 4 Driver Programmer’s
Reference
Neoview ODBC Drivers Manual
ODBC Client Administrator Online Help
README files
Neoview Support Library
Information about known problems that are visible to customers.README for Neoview Platform for
Reference information about the HP Neoview JDBC Type 4 Driver
API.
Information about using the HP Neoview JDBC Type 4 driver,
which provides Java applications on client workstations access a
Neoview database.
Information about using HP Neoview ODBC drivers on a client
workstation to access a Neoview database.
Context-sensitive help topics that describe how to use the ODBC
client interface.
— 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
Neoview Database Support Guide
18 About This Document
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.
Guide
Installation and replacement procedures.Neoview Hardware Installation and Support
Neoview Management Dashboard Support Guide
Neoview Migration and Upgrade Guide
Neoview ODBC and JDBC Troubleshooting
Guide
Neoview SQL Metadata Quick Reference
Neoview System Console Installer Guide
Neoview Query Support Guide
Neoview Virtual TapeServer Installation and
Support Guide
Neoview Workload Management Services Guide
Publishing History
Information on managing and configuring Dashboard from the
Dashboard Server and Client, including starting and running
Dashboard, usingDiscrete Object Thresholds (DOTs), using Dashboard
Command Interpretercommands, usingthe EntityDefinition Language
(EDL), and using Dashboard data definitions and record declarations.
Procedures for adding hardware, installing RVUs and updating other
software and firmware.
Guidelines for troubleshooting ODBC and JDBC connectivity to an
HP Neoview data warehousing platform.
Quick guide to schemas, tables, columns, and data types for Version
2000 Neoview SQL metadata.
Information about installing and configuring applications on the
Neoview system console
Information related to query execution plans and how to affect the
query performance of Neoview databases
Information about installing and maintaining the Neoview Virtual
TapeServer (VTS).
Information about using Neoview Workload Management Services
(NWMS) to manage workload and resources on a Neoview data
warehousing platform.
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:
pubs.comments@hp.com
Include the document title, part number, and any comment, error found, or suggestion for
improvement you have concerning this document.
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
Publishing History 19
20
1 Introduction to Neoview Script
Neoview Script is a command-line interface that you download and install on a client workstation
that has the Neoview JDBC Type 4 Driver installed. Operating systems that support the JDBC
driver include Windows, Linux, and UNIX. The JDBC driver connects Neoview Script on a client
workstation to a Neoview database on a Neoview data warehousing platform.
Figure 1-1 Neoview Script Within a Neoview Platform Network
Neoview Script enables you to perform daily administrative and database management tasks
by running SQL statements interactively or from script files. You can also run Neoview Script
from a Perl or Python command line or from Perl or Python programs. Neoview Script supports
many SQL statements. For a list of these statements, see Appendix B (page 133).
Neoview Script does not support:
• Adding, modifying, and deleting users
• Changing user passwords
• Job scheduling
21
22
2 Installing Neoview Script
NOTE: If you are manuallyinstalling Neoview Script on a Linux platformthat has the Neoview
data loader installed, use the services or sysadmin ID instead of root, which has been frozen for
the loader. The best way to install NeoviewScript on the loader platform is by using the Neoview
Loader Supplemental executive (Installsuppkt). For more information, see the Neoview Migration
and Upgrade Guide.
To install Neoview Script, follow these procedures:
1. Preinstallation procedures:
• “Installing and Verifying the Java Runtime Environment (JRE)” (page 23)
• “Installing and Verifying the Neoview JDBC Type 4 Driver” (page 26)
• “Installing Perl or Python” (page 27)
2. Installation procedures:
• “Downloading the Installer” (page 27)
• “Verifying the Version of the Installer File” (page 28)
• “Running the Installer” (page 28)
3. Postinstallation procedures:
• “Verifying the Installed Software Files” (page 34)
• “Verifying the Installed Version of Neoview Script” (page 35)
• “Setting the Look and Feel of the Neoview Script Interface” (page 35)
• “Testing the Launch of Neoview Script” (page 39)
Preinstallation Procedures
• “Installing and Verifying the Java Runtime Environment (JRE)” (page 23)
• “Installing and Verifying the Neoview JDBC Type 4 Driver” (page 26)
• “Installing Perl or Python” (page 27)
Installing and Verifying the Java Runtime Environment (JRE)
Neoview Script and the Neoview JDBC Type 4 Driver require a compatible Java version to be
installed on the client workstation. The supported Java versions are:
• JRE 1.4.2
• JRE 1.4.2_01, 1.4.2_02, 1.4.2_03, 1.4.2_04, 1.4.2_05, 1.4.2_06, 1.4.2_07, 1.4.2_10, and 1.4.2_11
These Java versions are not supported:
• Versions before 1.4.2
• Version 1.5
If you are using U.S. Daylight Savings Time (DST), be aware that the start and stop dates for
DST will change from the first Sunday in April to the second Sunday in March and from the last
Sunday in October to the first Sunday in November, starting in 2007. To avoid using incorrect
times, make sure that your Java Runtime Environment uses the correct DST rules. JRE 1.4.2_11
and later versions support the new DST rules.
Installing a Supported Java Version
To install one of the supported Java versions on the client workstation, follow the instructions
on the Sun Microsystems Web site:
http://java.sun.com/j2se/desktopjava/jre/index.jsp
Preinstallation Procedures 23
After installing the Java version, proceed with “Verifying the Java Version” (page 24).
Verifying the Java Version
To display the Java version of the client workstation on the screen, enter:
java -version
For example:
C:\>java -version
java version "1.4.2_10"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_10-b03)
Java HotSpot(TM) Client VM (build 1.4.2_10-b03, mixed mode)
C:\>
If the returned version is not supported or is unavailable, see:
• “Setting the PATH to a Supported Java Version on Windows” (page 24)
• “Setting the PATH to a Supported Java Version on Linux or UNIX” (page 26)
Setting the PATH to a Supported Java Version on Windows
1. Right-click the My Computer icon on your desktop, and then select Properties:
2. In the System Properties dialog box, click the Advanced tab.
3. Click the Environment Variables button:
24 Installing Neoview Script
4. Under System variables, select the variable named Path, and then click Edit:
Preinstallation Procedures 25
5. Place the cursor at the beginning of the Variable Value field and type the path of the Java
bin directory, ending with a semicolon (;):
For example:
"C:\Program Files\Java\j2re1.4.2_10\bin";
NOTE: Check that no space is after the semicolon (;) in the path. If there are spaces in the
directory name, delimit the entire directory path in double quotes (") before the semicolon.
6. Click OK.
7. Verify that the updated Path appears under System variables, and click OK.
8. In the System Properties dialog box, click OK to accept the changes.
Setting the PATH to a Supported Java Version on Linux or UNIX
1. Open the user profile (.profile or .bash_profile for the Bash shell) in the /home
directory. For example:
vi .profile
2. In the user profile, set the PATH environment variable to include the path of the Java bin
directory. For example:
export PATH=/opt/java1.4/jre/bin:$PATH
NOTE: Place the path of the Java bin directory before $PATH, and check that no space is
after the colon (:) in the path. In the C shell, use the setenv command instead of export.
3. To activate the changes, either log out and log in again or execute the user profile. For
example:
. .profile
Installing and Verifying the Neoview JDBC Type 4 Driver
Neoview Script requires a compatible JDBC driver to be installed on the client workstation. For
Neoview Release 2.1, Neoview Script requires the JDBC Type 4 Driver for Neoview Release 2.1.
Installing the JDBC Driver
To install the JDBC driver:
1. Download and extract the product distribution file.
2. Set the CLASSPATH to the product JAR file.
For information about how to install, verify, and use the JDBC driver, see the Neoview JDBC Type
4 Driver Programmer’s Reference or the product README.
Verifying the JDBC Driver
To display the version of the JDBC driver that is already installed on the client workstation:
26 Installing Neoview Script
1. Change the directory to the lib directory, which contains the JDBC driver JAR file:
• On Windows, enter this command:
cd jdbc-installation-directory\lib
jdbc-installation-directory is the directory where you installed the JDBC
driver.
• On Linux or UNIX, enter this command:
cd jdbc-installation-directory/lib
jdbc-installation-directory is the directory where you installed the JDBC
driver.
2. Enter this command to return version information:
java -jar hpt4jdbc.jar
For example:
C:\>cd install\hpt4jdbc\lib
C:\install\hpt4jdbc\lib>java -jar hpt4jdbc.jar
T1249_N24_AAK(R2.1)_11MAY07_HP_JDBCT4_2007_04_05
C:\install\hpt4jdbc\lib>
If the JAR file is inaccessible or the returned version is not supported, see “Installing the JDBC
Driver” (page 26).
Installing Perl or Python
If you plan to use Perl or Python scripts with Neoview Script, verify that you have Perl or Python
installed on the client workstation. Neoview Script supports these versions of Perl and Python:
• Perl version 5.6.1
• Python version 2.3.4
If you do not have Perl or Python, download it from any open source software provider. You
can perform this installation procedure anytime before or after installing Neoview Script.
NOTE: Neoview Script provides a beta version of enhanced support for Perl and Python
programs. This beta version requires Jython (for Python programs) and a different version of
Perl to be installed on the client workstation. For more information, see the README in the
Neoview Script samples directory.
Installation Procedures
NOTE: Before following the installation procedures, you must install the Neoview JDBC Type
4 Driver on the client workstation. For more information, see “Preinstallation Procedures”
(page 23).
• “Downloading the Installer” (page 27)
• “Verifying the Version of the Installer File” (page 28)
• “Running the Installer” (page 28)
Downloading the Installer
The NeoviewScript softwareis available as a downloadable installer file, hpnvsInstaller.jar,
on the Software Depot site.
Installation Procedures 27
1. Locate or create a directory or folder for the installer file anywhere on the client workstation.
2. On the client workstation, start a Web browser and navigate to the download site:
http://www.software.hp.com
3. Enter “Neoview Script” in the search box in the upper right corner of the Software Depot
home page.
4. Click the HP Neoview Script link that appears in the search results.
5. Follow instructions to download HP Neoview Script, which includes the
hpnvsInstaller.jar file, to the directory or folder in Step 1.
NOTE: In the File Download dialog box, make sure to select the Save or Save this file to
disk option.
Verifying the Version of the Installer File
To display the version of the downloaded installer file:
1. Change to the directory where you downloaded the Neoview Script installer file:
cd installer-directory
installer-directory is the directory where you downloaded the installer.
2. Enter this command to return version information:
java -jar hpnvsInstaller.jar v
For example:
C:\>cd download
C:\download>java -jar hpnvsInstaller.jar v
T0774_N24_AAC(R2.1)_11MAY07_HP_hpnvs_2007_04_12
C:\download>
Running the Installer
NOTE: Before running the installer, you must install the Neoview JDBC Type 4 Driver on the
client workstation. For more information, see “Preinstallation Procedures” (page 23).
You have a choice of running the installer from the Installer Wizard Graphical User Interface
(GUI) or from the command line:
• “Installer Wizard Steps” (page 28)
• “Command-Line Installation Steps” (page 33)
Installer Wizard Steps
NOTE: On Linux or UNIX, to run the Installer Wizard, you must have the X Window system
installed on the client workstation. If the client workstation does not have the X Window system,
see the “Command-Line Installation Steps” (page 33).
Launching the Installer Wizard
1. Locate the hpnvsInstaller.jar file in the folder where you downloaded the installer.
2. Verify that the hpnvsInstaller.jar file appears as an Executable JAR File.
If not, skip the next two steps and go to Step 5.
3. Double-click the hpnvsInstaller.jar file icon to launch the Installer Wizard.
4. Proceed to “Using the Installer Wizard” (page 29).
28 Installing Neoview Script
5. At a command prompt, change to the directory where you downloaded the installer:
cd installer-directory
installer-directory is the directory where you downloaded the installer file,
hpnvsInstaller.jar.
6. Launch the Installer Wizard by entering:
java -jar hpnvsInstaller.jar
7. Proceed to “Using the Installer Wizard” (page 29).
Using the Installer Wizard
When you execute hpnvsInstaller.jar, the Installer Wizard appears:
1. To locate the JDBC driver JAR file, click Browse next to HP Neoview JDBC Type 4 Driver
JAR file:
2. Select the lib folder of the JDBC driver, and then click Open:
Installation Procedures 29
3. Select hpt4jdbc.jar so that it appears in the File Name box, and then click Select:
The Installer Wizard now displays the path of the JDBC driver JAR file:
30 Installing Neoview Script
Loading...