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

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.

from materials supplied by the following:

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.

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)

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 ]

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

Popular Software manuals by other brands

COMPRO

COMPRO COMPROFM manual

Muratec

Muratec OFFICEBRIDGE ONLINE user guide

Oracle

Oracle Contact Center Anywhere 8.1 installation guide

Adobe

Adobe 65007312 - Photoshop Lightroom Programmer's guide

Avaya

Avaya NULL One-X for RIM Blackberry user guide

PS Audio

PS Audio PowerPlay Programming manual

Brady

Brady LOCKOUT PRO 3.0 Administrator's guide

Avaya

Avaya Interaction Center user guide

Texas Instruments

Texas Instruments TI-83 Plus Silver Edition Guide book

Novell

Novell GROUPWISE 8 - INTERNET AGENT manual

Oracle

Oracle Application 9i Configuration guide

Acer

Acer RDM user guide

Canon

Canon Vixia HF21 instruction manual

Canon

Canon ZR950 instruction manual

Samsung

Samsung Auto Backup user manual

Polycom

Polycom Vortex EF2201 Application note

Brocade Communications Systems

Brocade Communications Systems Brocade 8/12c user manual

Novell

Novell SP2 - S release note