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