HP Neoview Messages User manual

HP Neoview Messages Manual (Volume 1)
HP Part Number: 611472-001
Published: August 2010
Edition: HP Neoview Release 2.5

©Copyright 2010 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.........................................................................................................5
This Manual Has Two Volumes..............................................................................................................5
Supported Releases.................................................................................................................................5
Audience.................................................................................................................................................5
ODBC and JDBC Messages.....................................................................................................................5
Document Organization.........................................................................................................................5
New and Changed Information..............................................................................................................6
Notation Conventions.............................................................................................................................7
Hypertext Links.................................................................................................................................7
General Syntax Notation...................................................................................................................7
Notation for Messages.......................................................................................................................8
Related Documentation..........................................................................................................................9
Neoview Customer Library...............................................................................................................9
Publishing History................................................................................................................................11
HP Encourages Your Comments..........................................................................................................11
1 Message Handling......................................................................................................13
Viewing Neoview Database Messages.................................................................................................13
SQLSTATE and SQLCODE...................................................................................................................13
Contacting Your Service Provider........................................................................................................14
2 Data Definition Language (DDL) Messages (1000 Through 1999).........................15
3 Neoview Compiler Messages (2000 Through 2999)..............................................67
4 Parser and Compilation Messages (3000 Through 3999).....................................89
5 Binder and Compilation Messages (4000 Through 4999)..................................131
6 Normalizer Messages (5000 Through 5999)........................................................171
7 Optimizer Messages (6000 Through 6999)..........................................................173
8 Generator Messages (7000 Through 7999)..........................................................179
9 Executor Messages (8000 Through 8999).............................................................185
10 UPDATE STATISTICS Messages (9200 Through 9218)........................................225
11 Executor Sort and Scratch File I/O Messages (10000 Through 10199)............229
Executor Sort Messages (10000–10049)...............................................................................................229
Scratch File I/O Messages (10101–10199)............................................................................................233
Table of Contents 3

12 Trigger, UDR Server, and Language Manager Messages (11000 Through
11399).............................................................................................................................239
13 Materialized Views Messages (12000 Through 12329)......................................251
14 Messages Generated by the Message System (16000 Through 16999)...........267
15 Internal Stored Procedures Messages (19000 Through 19999).........................269
16 Utility Messages (20000 Through 23099)...........................................................271
17 Authentication and User Management Messages (24000 Through 24999)....333
18 Versioning, Distribution, and JDBC Messages (25000 Through 25499 and
29000 Through 29399)...............................................................................................351
Versioning Messages (25000–25399)...................................................................................................351
Distribution Messages (25400–25499).................................................................................................361
JDBC Driver Error Messages (29000–29399).......................................................................................366
19 Neoview Command Interface (NCI) Messages (29400 Through (29599).......367
20 Rowsets Messages (30000 Through 30999).......................................................379
21 File-System Errors.....................................................................................................385
New or Changed File-System Errors for the Neoview Platform........................................................398
4 Table of Contents

About This Document
The Neoview SQL database is the HP relational database management system (RDBMS) based
on ANSI SQL-92. It uses the industry standard Structured Query Language (SQL) to define and
manipulate data. This manual describes messages produced by the HP Neoview data warehousing
platform and its associated subsystems.
This Manual Has Two Volumes
The Neoview Messages Manual has two volumes:
•Neoview Messages Manual (Volume 1)
•Neoview Messages Manual (Volume 2)
Be sure to consult both volumes for messages information.
Supported Releases
This manual supports Neoview Release 2.5 and subsequent Neoview releases until otherwise
indicated in a replacement publication.
Audience
This manual was written for Neoview database administrators and programmers who use the
Neoview database. Readers of this manual should know the fundamentals of:
•Neoview database software
•HP Neoview platform
ODBC and JDBC Messages
ODBC messages are contained in the Neoview ODBC Drivers Manual.
JDBC messages are contained in the Neoview JDBC Type 4 Driver Programmer's Reference.
Additional JDBC messages appear in the README for HP Neoview Release 2.5.
Document Organization
Chapter 1 (page 13) is an introduction to Neoview software message handling.
The remaining chapters list SQL messages or file-system errors in numeric order. To find a
particular message description, search the document for the message number. These chapters
are:
TitleChapter
“Message Handling”Chapter 1 (page 13)
“Data Definition Language (DDL) Messages (1000 Through 1999)”Chapter 2 (page 15)
“Neoview Compiler Messages (2000 Through 2999)”Chapter 3 (page 67)
“Parser and Compilation Messages (3000 Through 3999)”Chapter 4 (page 89)
“Binder and Compilation Messages (4000 Through 4999)”Chapter 5 (page 131)
“Normalizer Messages (5000 Through 5999)”Chapter 6 (page 171)
“Optimizer Messages (6000 Through 6999)”Chapter 7 (page 173)
“Generator Messages (7000 Through 7999)”Chapter 8 (page 179)
“Executor Messages (8000 Through 8999)”Chapter 9 (page 185)
This Manual Has Two Volumes 5

TitleChapter
“UPDATE STATISTICS Messages (9200 Through 9218)”Chapter 10 (page 225)
“Executor Sort and Scratch File I/O Messages (10000 Through 10199)”Chapter 11 (page 229)
“Trigger, UDR Server, and Language Manager Messages (11000 Through 11399)”Chapter 12 (page 239)
“Materialized Views Messages (12000 Through 12329)”Chapter 13 (page 251)
“Messages Generated by the Message System (16000 Through 16999)”Chapter 14 (page 267)
“Internal Stored Procedures Messages (19000 Through 19999)”Chapter 15 (page 269)
“Utility Messages (20000 Through 23099)”Chapter 16 (page 271)
Chapter 17 (page 333)Chapter 17 (page 333)
“Versioning, Distribution, and JDBC Messages (25000 Through 25499 and 29000 Through
29399)”
Chapter 18 (page 351)
“Neoview Command Interface (NCI) Messages (29400 Through (29599)”Chapter 19 (page 367)
“Rowsets Messages (30000 Through 30999)”Chapter 20 (page 379)
“File-System Errors”Chapter 21 (page 385)
New and Changed Information
Changed information includes new and changed messages. The chapters that have new or
changed messages are listed together with the added or changed message numbers.
Messages Added or ChangedDescriptionChapter (page)
1085, 1143, 1168, 1176, 1177, 1178, 1179, 1194,
1277, 1299, 1314, 1315, 1324, 1325, 1596, 1597,
1598, 1599, 1600, 1601
“Data Definition Language (DDL) Messages
(1000 Through 1999)”
Chapter 2 (page 15)
4347, 4348, 4349, 4381, 4382, 4390, 4419“Binder and Compilation Messages (4000
Through 4999)”
Chapter 5 (page 131)
6007, 6008, 6010, 6011, 6012, 6013, 6015Chapter 7 (page 173)Chapter 7 (page 173)
7350, 7351, 7352Chapter 8 (page 179)Chapter 8 (page 179)
8013, 8023, 8025, 8026, 8027, 8028, 8029, 8030,
8579, 8596, 8650, 8651, 8652, 8653, 8654, 8655,
8656, 8657, 8658, 8659, 8660, 8661, 8662, 8665,
8666, 8667, 8837, 8839, 8855, 8857, 8923
“Executor Messages (8000 Through 8999)”Chapter 9 (page 185)
9200Chapter 10 (page 225)Chapter 10 (page 225)
11041, 11213, 11214, 11215, 11216, 11217,
11218, 11219, 11220
Chapter 12 (page 239)Chapter 12 (page 239)
12118, 12119, 12331, 12333, 12334“Materialized Views Messages (12000
Through 12329)”
Chapter 13 (page 251)
20216, 20235, 20505“Utility Messages (20000 Through 23099)”Chapter 16 (page 271)
6

Messages Added or ChangedDescriptionChapter (page)
This chapter is new. 24001, 24002, 24003,
24004, 24005, 24006, 24007, 24008, 24009,
24010, 24011, 24012, 24013, 24014, 24015,
24016, 24017, 24019, 24020, 24021, 24022,
24023, 24026, 24027, 24028, 24029, 24030,
24031, 24033, 24034, 24036, 24037, 24039,
24040, 24041, 24042, 24043, 24044, 24045,
24046, 24047, 24049, 24050, 24051, 24052,
24053, 24055, 24056, 24057, 24059, 24062,
24069, 24070, 24071, 24073, 24074, 24077,
24079, 24081, 24082, 24083, 24084, 24085,
24086, 24087, 24088, 24089, 24090, 24091,
24092, 24093, 24094, 24095, 24096, 24097,
24098, 24099, 24100, 24101, 24102, 24103,
24104, 24105, 24110, 24111, 24112, 24114,
24115, 24116, 24117, 24118, 24119, 24120,
24121, 24122, 24123, 24124, 24125, 24126,
24127, 24128, 24129, 24130, 24131, 24134,
24135, 24137, 24139
Chapter 17 (page 333)Chapter 17 (page 333)
0757“File-System Errors”Chapter 21 (page 385)
Notation Conventions
Hypertext Links
Blue underline is used to indicate a hypertext link within text. By clicking a passage of text with
a blue underline, you are taken to the location described. For example:
Rowset errors are listed in Chapter 20 (page 379).
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
lowercase italic letters
Lowercase italic letters 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
italic computer type
Italic computer type letters within text indicate variable items that you supply. Items not
enclosed in brackets are required. For example:
pathname
Punctuation
Notation Conventions 7

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]
Notation for Messages
This list summarizes the notation conventions for the presentation of displayed messages in this
manual.
Bold Text
Bold text in an example indicates user input typed at the terminal. For example:
ENTER RUN CODE
?123
CODE RECEIVED: 123.00
The user must press the Return key after typing the input.
Nonitalic text
Nonitalic letters, numbers, and punctuation indicate text that is displayed or returned exactly
as shown. For example:
Backup Up.
lowercase italic letters
Lowercase italic letters indicate variable items whose values are displayed or returned. For
example:
p-register
process-name
[ ] Brackets
Brackets enclose items that are sometimes, but not always, displayed. For example:
Event number = number [ Subject = first-subject-value ]
8

A group of items enclosed in brackets is a list of all possible items that can be displayed, of which
one or none might actually be displayed. 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:
proc-name trapped [ in SQL | in SQL file system ]
{ } Braces
A group of items enclosed in braces is a list of all possible items that can be displayed, of which
one is actually displayed. 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:
obj-type obj-name state changed to state, caused by
{ Object | Operator | Service }
process-name State changed from old-objstate to objstate
{ Operator Request. }
{ Unknown. }
| Vertical Line
A vertical line separates alternatives in a horizontal list that is enclosed in brackets or braces. For
example:
Transfer status: { OK | Failed }
% Percent Sign
A percent sign precedes a number that is not in decimal notation. The % notation precedes an
octal number. The %B notation precedes a binary number. The %H notation precedes a
hexadecimal number. For example:
%005400
%B101111
%H2F
P=%p-register E=%e-register
Related Documentation
This manual is part of the HP Neoview library, which includes:
Neoview Customer Library
The manuals in the Neoview customer library are listed here for your convenience.
•Administration
Information about security features on the Neoview platform, including user
and role management for database and platform users, support for integration
with Lightweight Directory Access Protocol (LDAP) directory servers,
password encryption, and database security.
Neoview User Management and
Security Guide
Information for database administrators and end users of the Neoview
Character Sets product, including rules for defining and managing character
data using SQL language elements, capabilities and limitations of Neoview
client applications, troubleshooting character set-related problems, and enabling
Pass-Through mode in the ISO88591 configuration.
Neoview Character Sets
Administrator's Guide
Introduction to the Neoview database, database users and IDs, database
management, and management tools.
Neoview Database
Administrator’s Guide
Related Documentation 9

Information about how to use stored procedures that are written in Java within
a Neoview database.
Neoview Guide to Stored
Procedures in Java
Information about reviewing query execution plans and investigating query
performance of Neoview databases.
Neoview Query Guide
Information about processes and commands for loading data into your
Neoview platform or extracting data from it.
Neoview Transporter User Guide
— README for the HP Neoview Windows Client Package
— README for the HP Neoview Transporter Java Client
README files for installing
Administration client products
•Management
Help topics that describe how to use the HP Database Manager client to monitor
and manage a Neoview data warehousing platform.
HP Database Manager (HPDM)
Online Help
Information for database administrators about how to monitor and manage
a Neoview data warehousing platform using the HP Database Manager.
HP Database Manager (HPDM)
User Guide
Information about using the HP Neoview Command Interface to run SQL
statements interactively or from script files.
Neoview Command Interface
(NCI) Guide
Command-line help that describes the commands supported in the current
operating mode of Neoview Command Interface.
Neoview Command Interface
(NCI) Online Help
Context-sensitive help topics that describe how to use the Neoview
Performance Analysis Tools to analyze and troubleshoot query-related issues
on the Neoview data warehousing platform.
Neoview Performance Analysis
Tools Online Help
Information about how to use the Neoview Performance Analysis Tools to
analyze and troubleshoot query-related issues on the Neoview data
warehousing platform.
Neoview Performance Analysis
Tools User Guide
Information about using the Repository, including descriptions of Repository
views and guidelines for writing Neoview SQL queries against the views.
Neoview Repository User Guide
Information about the logging of user-management actions on the Neoview
platform and the facilities available for monitoring such actions.
Neoview User Management
Information
Information about using Neoview Workload Management Services (WMS) to
manage workload and resources on a Neoview data warehousing platform.
Neoview Workload Management
Services Guide
— README for the HP Neoview Windows Client Package
— README for the HP Database Manager (HPDM)
— README for the HP Neoview Command Interface (NCI)
— README for the HP Neoview Performance Analysis Tools
README files for installing
Management client products
•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 to 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
Information about using HP Neoview ADO.NET to access data and services
stored on the Neoview database.
Neoview ADO.NET Data
Provider Manual
10