HP NonStop SQL/MX User manual

HP NonStop SQL/MX
Messages Manual
Abstract
This manual describes messages produced by the HP NonStop™ SQL/MX relational
database management system and its associated subsystems.
Product Version
NonStop SQL/MX Release 3.0
Supported Release Version Updates (RVUs)
This publication supports J06.11 and all subsequent J-series RVUs and H06.22 and all
subsequent H-series RVUs, until otherwise indicated by its replacement publications.
Part Number Published
640324-001 February 2011

Document History
Part Number Product Version Published
640324-001 NonStop SQL/MX Release 3.0 February 2011

Legal Notices
©Copyright 2011 Hewlett-Packard Development Company L.P.
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, Itanium, Pentium, and Celeron are trademarks or registered trademarks of Intel Corporation or its
subsidiaries in the United States and other countries.
Java® is a registered trademark of Oracle and/or its affiliates.
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. This documentation and the 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.
This 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.
Printed in the US

Hewlett-Packard Company—640324-001
i
HP NonStop SQL/MX Messages
Manual
Glossary Figures
Legal Notices
What’s New in This Manual v
Manual Information v
New and Changed Information v
About This Manual xi
Audience xi
Related Documentation xi
Notation Conventions xiv
HP Encourages Your Comments xvi
1. Message Handling
Viewing SQL/MX Messages 1-1
Non-SQLCODE Error Messages 1-2
Messages That Report a Guardian File System Error 1-2
SQLSTATE and SQLCODE 1-3
Contacting Your Service Provider 1-3
Process Control Procedure Errors 1-4

Contents
HP NonStop SQL/MX Messages Manual—640324-001
ii
2. General Messages (0 through 999)
2. General Messages (0 through 999)
3. Data Definition Language (DDL) Messages (1000 through
1999)
4. SQL/MX MXCMP Messages (2000 through 2999)
5. Parser and Compilation Messages (3000 through 3999)
6. Binder and Compilation Messages (4000 through 4999)
7. Normalizer Messages (5000 through 5999)
8. Optimizer Messages (6000 through 6999)
9. Generator Messages (7000 through 7999)
10. Executor Messages (8000 through 8999)
11. UPDATE STATISTICS Messages (9200 through 9221)
12. Executor Sort and Scratch File I/O Messages (10000 through
10199)
Executor Sort Messages 12-1
Scratch File I/O Messages 12-12

Contents
HP NonStop SQL/MX Messages Manual—640324-001
iii
13. Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
13. Trigger, UDR Server, and Language Manager Messages
(11000 through 11399)
14. SQLC and SQLCO Preprocessor Messages (13000 through
13999)
15. MXCI Messages (15000 through 15999)
16. Messages Generated by the Message System (16000
through 16999)
17. Internal Stored Procedures Messages (19000 through 19999)
18. Utility Messages (20000 through 23099)
19. Versioning and Distribution Messages (25000 through
25399)
Distribution Messages (25400-25499) 19-25
JDBC Driver Error Messages (29000-29999) 19-32
20. Rowsets Messages (30000 through 30999)
21. SQLSTATE Values Returned by NonStop SQL/MX
SQLSTATE and SQLCODE Considerations 21-1
SQLSTATE Values 21-2
A. Non-SQLCODE Error Messages
InstallSqlmx script A-1
Metadata Migration Utility A-6
MXGNAMES Utility A-11
Tables
Table 21-1. SQLSTATE Values 21-2

Contents
HP NonStop SQL/MX Messages Manual—640324-001
iv

HP NonStop SQL/MX Messages Manual—640324-001
v
What’s New in This Manual
Manual Information
HP NonStop SQL/MX Messages Manual
Abstract
This manual describes messages produced by the HP NonStop™ SQL/MX relational
database management system and its associated subsystems.
Product Version
NonStop SQL/MX Release 3.0
Supported Release Version Updates (RVUs)
This publication supports J06.11 and all subsequent J-series RVUs and H06.22 and all
subsequent H-series RVUs, until otherwise indicated by its replacement publications.
Document History
New and Changed Information
Changes to the 640324-001 manual:
•Updated the following error messages:
°SQL 1004
°SQL 1020
°SQL 1055
°SQL 1080
°SQL 1085
°SQL 1087
°SQL 1098
°SQL 1112
°SQL 1132
°SQL 1140
Part Number Published
640324-001 February 2011
Part Number Product Version Published
640324-001 NonStop SQL/MX Release 3.0 February 2011

What’s New in This Manual
HP NonStop SQL/MX Messages Manual—640324-001
vi
New and Changed Information
°SQL 1143
°SQL 1150 and SQL 1151
°SQL 1225
°SQL 1238
°SQL 1239
°SQL 1263
°SQL 1270 and SQL 1271
°SQL 1500 through SQL 1503
°SQL 2011 through SQL 2020
°SQL 2027 and SQL 2028
°SQL 2033 and SQL 2034
°SQL 2055
°SQL 2984
°SQL 3008
°SQL 3014
°SQL 4082
°SQL 4129
°SQL 4161
°SQL 4320
°SQL 6003
°SQL 6008
°SQL 8402
°SQL 8411
°SQL 8419
°SQL 8834
°SQL 8837
°SQL 9215
°SQL 10003 through SQL 10013
°SQL 10015 through SQL 10024
°SQL 10026 through SQL 10029

What’s New in This Manual
HP NonStop SQL/MX Messages Manual—640324-001
vii
New and Changed Information
°SQL 10049
°SQL 11041
°SQL 11022
°SQL 11027
°SQL 11101 through SQL 11111
°SQL 11209
°SQL 11242 through SQL 11244
°SQL 19020
°SQL 20011
°SQL 20025
°SQL 20037
°SQL 20123
°SQL 20127
°SQL 20137
°SQL 20142
°SQL 20149
°SQL 20154 and SQL 20155
°SQL 20176
°SQL 20354
°SQL 20360
°SQL 20371
°SQL 20733
°SQL 20752
°SQL 20755
°SQL 20759
°SQL 20779
°SQL 20795
°SQL 23001 through SQL 23003
°SQL 23007
°SQL 23011 through SQL 23020

What’s New in This Manual
HP NonStop SQL/MX Messages Manual—640324-001
viii
New and Changed Information
°SQL 25208
°SQL 25214
°SQL 25216
°SQL 25302 and SQL 25303
°SQL 25308
°SQL 25310
•Added the following error messages:
°SQL 1154
°SQL 1158
°SQL 1159
°SQL 1165
°SQL 1168
°SQL 1174
°SQL 1189
°SQL 1193 and SQL 1195
°SQL 1249
°SQL 1276
°SQL 1277
°SQL 1278
°SQL 1289
°SQL 1295
°SQL 1311 and SQL 1312
°SQL 1401
°SQL 1506
°SQL 2235
°SQL 3218
°SQL 3409
°SQL 3415
°SQL 4193
°SQL 4195 and SQL 4196

What’s New in This Manual
HP NonStop SQL/MX Messages Manual—640324-001
ix
New and Changed Information
°SQL 4198
°SQL 4220
°SQL 4336 through SQL 4338
°SQL 4353
°SQL 4362
°SQL 6004
°SQL 8019
°SQL 8022
°SQL 8401
°SQL 8432 and SQL 8433
°SQL 8581
°SQL 8598
°SQL 8887
°SQL 8889
°SQL 8900
°SQL 8916 and SQL 8917
°SQL 10025
°SQL 10030 through SQL 10043
°SQL 10045 and SQL 10046
°SQL 10051
°SQL 10101 through SQL 10119
°SQL 10130 through SQL 10141
°SQL 10150 through SQL 10153
°SQL 11002
°SQL 11046
°SQL 11049
°SQL 15001
°SQL 15039
°SQL 19022
°SQL 20339 and SQL 20340

What’s New in This Manual
HP NonStop SQL/MX Messages Manual—640324-001
x
New and Changed Information
°SQL 20376 and SQL 20377
°SQL 20454
°SQL 20520 through SQL 20532
°SQL 20562
°SQL 20588 and SQL 20589
°SQL 20794
°SQL 20816
°SQL 20820 through SQL 20822
°SQL 20877
°SQL 25003
°SQL 25006
°SQL 25007
°SQL 25209
°SQL 25220 through SQL 25222
°SQL 25250 through SQL 25268
°SQL 30026 through SQL 30029
°SQL 30035
°SQL 30037
•Added SQLSTATE 21000 on page 21-45.
•Removed SQL message 2054.
•Changed SQL message 8910 to 8916 and updated its description on page 10-53.
•Changed SQL message 8911 to 8917 and updated its description on page 10-54.
•Removed SQL message 20240.
•Removed SQL messages from 20278 through 20289.
•Removed SQL message 25105.
•Removed SQL message 25304.

HP NonStop SQL/MX Messages Manual—640324-001
xi
About This Manual
NonStop SQL/MX is the HP relational database management system based on ANSI
SQL-92. It uses the industry standard Structured Query Language (SQL) to define and
manipulate data. This manual lists messages produced by NonStop SQL/MX and
related subsystems.
Audience
This manual is for NonStop SQL/MX database administrators and programmers who
use the NonStop SQL/MX conversational or programmatic interface.
Readers of this manual must know the:
•fundamentals of NonStop SQL/MX
•fundamentals of the HP NonStop operating system
•fundamentals of the SQL/MX conversational interface (MXCI)
Related Documentation
This manual is part of the SQL/MX library of manuals, which includes:
Introductory Guides
SQL/MX Comparison Guide
for SQL/MP Users Describes SQL differences between NonStop SQL/MP and NonStop SQL/MX.
SQL/MX Quick Start Describes basic techniques for using SQL in the
SQL/MX conversational interface (MXCI). Includes
information about installing the sample database.
Reference Manuals
SQL/MX Reference Manual Describes the syntax of SQL/MX statements, MXCI
commands, functions, and other SQL/MX language
elements.
SQL/MX Messages Manual Describes SQL/MX messages.
SQL/MX Glossary Defines SQL/MX terminology.
Installation Guides
SQL/MX Installation and
Management Guide Describes how to plan for install, create, and manage an SQL/MX database. Explains how to use
installation and management commands and
utilities.
NSM/web Installation Guide Describes how to install NSM/web and troubleshoot
NSM/web installations.

About This Manual
HP NonStop SQL/MX Messages Manual—640324-001
xii
Related Documentation
Connectivity Manuals
SQL/MX Connectivity
Service Manual Describes how to install and manage the HP NonStop SQL/MX Connectivity Service
(MXCS), which enables applications developed for
the Microsoft Open Database Connectivity (ODBC)
application programming interface (API) and other
connectivity APIs to use NonStop SQL/MX.
SQL/MX Connectivity
Service Administrative
Command Reference
Describes the SQL/MX administrative command
library (MACL) available with the SQL/MX
conversational interface (MXCI).
ODBC/MX Driver for
Windows Describes how to install and configure HP NonStop ODBC/MX for Microsoft Windows, which enables
applications developed for the ODBC API to use
NonStop SQL/MX.
Migration Guides
SQL/MX Database and
Application Migration Guide Describes how to migrate databases and applications to NonStop SQL/MX and how to
manage different versions of NonStop SQL/MX.
NonStop NS-Series
Database Migration Guide Describes how to migrate NonStop SQL/MX, NonStop SQL/MP, and Enscribe databases and
applications to HP Integrity NonStop NS-series
systems.
Data Management Guides
SQL/MX Data Mining Guide Describes the SQL/MX data structures and
operations to carry out the knowledge-discovery
process.
SQL/MX Report Writer Guide Describes how to produce formatted reports using
data from an SQL/MX database.
DataLoader/MX Reference
Manual Describes the features and functions of the DataLoader/MX product, a tool to load SQL/MX
databases.
Application Development Guides
SQL/MX Programming
Manual for C and COBOL Describes how to embed SQL/MX statements in ANSI C and COBOL programs.
SQL/MX Query Guide Describes how to understand query execution
plans and write optimal queries for an SQL/MX
database.
SQL/MX Queuing and
Publish/Subscribe Services Describes how NonStop SQL/MX integrates transactional queuing and publish/subscribe
services into its database infrastructure.
SQL/MX Guide to Stored
Procedures in Java Describes how to use stored procedures that are written in Java within NonStop SQL/MX.

About This Manual
HP NonStop SQL/MX Messages Manual—640324-001
xiii
Related Documentation
The NSM/web and Visual Query Planner help systems are accessible from their
respective applications. You can download the Reference, Messages, and Glossary
online help by following the instructions mentioned under the SQL/MX Online Help and
Sample Programs document. This document can be accessed from the following
documentation links available at the HP Business Support Center (BSC),
http://www.hp.com/go/nonstop-docs:
•HP Integrity NonStop H-Series
•HP Integrity NonStop J-Series
These manuals are part of the SQL/MP library of manuals and are essential
references. For more information about SQL/MP Data Definition Language (DDL) and
SQL/MP installation and management:
These documents are helpful for understanding the concepts and terminology of this
manual:
Online Help
SQL/MX Reference Online
Help Overview and reference entries from the SQL/MX Reference Manual.
SQL/MX Messages Online
Help Individual messages grouped by source from the SQL/MX Messages Manual.
SQL/MX Glossary Online
Help Terms and definitions from the SQL/MX Glossary.
NSM/web Help Context-sensitive help topics that describe how to
use the NSM/web management tool.
Visual Query Planner Help Context-sensitive help topics that describe how to
use the Visual Query Planner graphical user
interface.
Related SQL/MP Manuals
SQL/MP Reference Manual Describes the SQL/MP language elements,
expressions, predicates, functions, and statements.
SQL/MP Installation and
Management Guide Describes how to plan, install, create, and manage an SQL/MP database. Describes installation and
management commands and SQL/MP catalogs
and files.
Other Related Documentation
Guardian Procedure Errors
and Messages Manual Describes the Guardian messages for HP NonStop systems that use HP NonStop Kernel operating
system.
Guardian Procedure Calls
Reference Manual Describes the syntax of Guardian procedure calls.

About This Manual
HP NonStop SQL/MX Messages Manual—640324-001
xiv
Notation Conventions
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:
This requirement is described under Backup DAM Volumes and Physical Disk
Drives on page 3-2.
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:
MAXATTACH
lowercase italic letters. Lowercase italic letters indicate variable items that you supply.
Items not enclosed in brackets are required. For example:
file-name
Punctuation. Parentheses, commas, semicolons, and other symbols not previously
described must be typed as shown. For example:
error := NEXTFILENAME ( file-name ) ;
LISTOPENS SU $process-name.#su-name
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:
"[" repetition-constant-list "]"
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:
CALL STEPMOM ( process-id ) ;
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:
$process-name.#su-name
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

About This Manual
HP NonStop SQL/MX Messages Manual—640324-001
xv
Notation for Messages
a blank line. This spacing distinguishes items in a continuation line from items in a
vertical list of selections. For example:
ALTER [ / OUT file-spec / ] LINE
[ , attribute-spec ]…
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

About This Manual
HP NonStop SQL/MX Messages Manual—640324-001
xvi
Change Bar Notation
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
Change Bar Notation
Change bars are used to indicate substantive differences between this edition of the
manual and the preceding edition. Change bars are vertical rules placed in the right
margin of changed portions of text, figures, tables, examples, and so on. Change bars
highlight new or revised information. For example:
The message types specified in the REPORT clause are different in the COBOL85
environment and the Common Run-Time Environment (CRE).
The CRE has many new message types and some new message type codes for
old message types. In the CRE, the message type SYSTEM includes all messages
except LOGICAL-CLOSE and LOGICAL-OPEN.
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 docsfeedba[email protected].
Include the document title, part number, and any comment, error found, or suggestion
for improvement concerning this document.