DB2 Error Messages (SQLCODE, SQLSTATE)

2011-04-19  来源:本站原创  分类:Database  人气:284 

SQLCODE SQLSTATE Description
000 00000 The SQL statement finished successfully.
  01xxx The SQL statement finished successfully, but with a warning.
+012 01545 The unqualified column name was interpreted as a correlated reference.
+098 01568 A dynamic SQL statement ends with a semicolon.
+100 02000 No rows found to satisfy the SQL statement.
+110 01561 Update to a table defined using DATA CAPTURE was not signaled to originating subsystem. (DPROP)
+111 01590 The SUBPAGES clause was specified (and ignored) for a Type 2 index.
+117 01525 The number of values being inserted does not equal the number of columns in the table being inserted to.
+162 01514 Named tablespace placed in check pending status.
+203 01552 The named qualified column was resolved using a non-unique name.
+204 01532 Named object is not defined to DB2.
+206 01533 Named column does not exist in any table named in the SQL statement.
+218 01537 EXPLAIN cannot be executed for the SQL statement as it references a remote object.
+219 01532 The named PLAN_TABLE does not exist.
+220 01546 Improperly defined PLAN_TABLE; check definition of named column.
+236 01005 The value of SQLN in the SQLDA should be at least as large as the number of columns that are being described.
+237 01594 At least one of the columns being described is a distinct type, so additional space is required for extended SQLVAR entries.
+238 01005 At least one of the columns being described is a LOB, so additional space is required for extended SQLVAR entries.
+239 01005 At least one of the columns being described is a distinct type, so additional space is required for extended SQLVAR entries.
+304 01515 Value cannot be assigned to host variable because it is out of range for the data type.
+331 01520 String cannot be translated so it has been assigned to NULL.
+339 01569 Character conversion problem may exist due to connection to a DB2 V2.2 subsystem.
+394 01629 Optimizer "hints" used to select the access path.
+395 01628 Invalid optimizer "hints" specified; reason code specifies why. Optimizer "hints" were ignored.
+402 01521 Unknown location.
+403 01522 CREATE ALIAS object does not exist locally.
+434 01608 The specified feature will not be supported in future releases of DB2. IBM recommends that you stop using this feature.
+445 01004 Value has been truncated by a CAST function.
+462 01Hxx Warning issued by user-defined function or stored procedure.
+464 01609 Named stored procedure exceeded the limit on the number of query results sets it can return.
+466 01610 Specifies the number of query results sets returned by the named stored procedure. Successful completion.
+494 01614 Number of results sets returned by a stored procedure exceeds the number of results set locators as specified by the ASSOCIATE LOCATORS statement.
+495 01616 Warning issued because the cost estimate for the dynamic SQL exceeds the warning threshold value specified in the RLST.
+535 01591 A positioned update of a primary key or a delete from a table with a self-referencing constraint was requested.
+541 01543 Named foreign key is a duplicate referential constraint.
+551 01548 Named authorization ID lacks authority to perform the named operation on the named DB2 object.
+552 01542 Named authorization ID lacks authority to perform the named operation.
+558 01516 Already granted to PUBLIC so WITH GRANT OPTION not applicable.
+561 01523 PUBLIC AT ALL LOCATIONS not valid for ALTER. REFERENCES, INDEX, and TRIGGER privileges.
+562 01560 One or more of the privileges was ignored because the GRANTEE already possesses that privilege.
+585 01625 Schema name is specified more than once.
+599 01596 Comparison functions are not created for long string data types (BLOB, CLOB, and DBCLOB).
+610 01566 The named object is in a PENDING status due to creating an index specifying DEFER YES or because ALTER INDEX was used to change limit key values.
+625 01518 Table definition marked incomplete because primary key index was dropped.
+626 01529 Index to enforce UNIQUE constraint has been dropped; uniqueness no longer enforced.
+645 01528 WHERE NOT NULL was ignored because the key for the index being created cannot contain NULLs.
+650 01538 Cannot alter or create the named table as a dependent table.
+653 01551 Partitioned index for the named table in the named partitioned tablespace has not been created yet, so it is unavailable.
+655 01597 Specific and non-specific volume IDs specified to the CREATE or ALTER STOGROUP statement; will not be supported in later DB2 releases (post V6).
+658 01600 Cannot specify SUBPAGES clause when creating a catalog index; SUBPAGES will be ignored and default to 1.
+664 01540 Limit key for the partitioning index exceeds the maximum value.
+738 01530 The change to the named object may require like changes for the objects in read-only systems.
+799 01527 A special register that does not exist is referenced in the SET statement. The SET request is ignored.
+802 01519 Data exception error caused by data overflow or divide exception.
+806 01553 ISOLATION(RR) conflicts with LOCKSIZE PAGE.
+807 01554 Overflow may result due to decimal multiplication.
+863 01539 Connection successful, but only SBCS will be supported.
+2000 56094 Type 1 indexes where SUBPAGES does not equal 1 cannot become group bufferpool dependent in a data sharing environment.
+2002 01624 The GBPCACHE specification is ignored because the specified bufferpool does not allow caching.
+2007 01602 Optimizer "hints" cannot be specified because the DB2 subsystem parameter disabling "hints" has been activated.
+30100 01558 Distribution protocol error detected. Original SQLCODE and SQLSTATE provided.
-007 42601 Illegal character in SQL statement.
-010 42603 String constant not terminated properly; check for missing quotation marks.
-029 42601 INTO clause required.
-060 42815 Invalid length or scale specification for the specified data type.
-084 42612 SQL statement cannot be executed because it is invalid for dynamic SQL or is not valid for DB2 for OS/390.
-097 42601 Cannot use LONG VARCHAR or LONG VARGRAPHIC with CAST, or in distinct types, user-defined functions, and procedures.
-101 54001 SQL statement exceeds an established DB2 limit; for example, too many tables, too many bytes in statement, and so on.
-102 54002 String constant is too long.
-103 42604 Invalid numeric literal.
-104 42601 Illegal symbol encountered in SQL statement.
-105 42604 Invalid character string format; usually refers to an improperly formatted graphic string.
-107 42622 Object name is too long.
-108 42601 Incorrect name specified for the RENAME statement; cannot use a qualifier.
-109 42601 Invalid clause specified; for example: CREATE VIEW cannot contain an ORDER BY clause.
-110 42606 Invalid hexadecimal literal encountered.
-111 42901 Column function specified without a column name.
-112 42607 Invalid column function syntax; column function cannot operate on another column function.
-113 42602 Invalid character encountered.
-114 42961 Location name for this statement must match the current server, but it does not.
-115 42601 Invalid predicate encountered because comparison operator is not followed by an expression or list.
-117 42802 Number of inserted values not equivalent to number of columns for the inserted row.
-118 42902 Table or view is illegally named in both data modification clause (UPDATE or DELETE) and the FROM clause.
-119 42803 Column list in HAVING clause does not match column list in the GROUP BY clause.
-120 42903 The WHERE clause, SET clause, VALUES clause, or SET ASSIGNMENT statement is not allowed to reference a column function.
-121 42701 A column is illegally referenced twice in an INSERT or UPDATE statement.
-122 42803 Column function applied illegally because all columns not applied to a column function are not in the GROUP BY clause.
-123 42601 The parameter in the specified position must be either a constant or a key word.
-125 42805 Invalid number specified in the ORDER BY clause--number is either less than 1 or greater than the number of columns selected.
-126 42829 An ORDER BY clause cannot be specified for an UPDATE statement.
-127 42905 DISTINCT can only be specified once in a subselect.
-128 42601 NULL use improperly in an SQL predicate.
-129 54004 The SQL statement contains more than 15 tables.
-130 22019 Escape clause must be 1 character.
  22025 Invalid escape pattern.
-131 42818 The LIKE predicate can only be applied to character data.
-132 42824 Invalid operand in LIKE clause, ESCAPE clause, LOCATE function, or POSSTR function.
-133 42906 Invalid correlated subquery reference.
-134 42907 Column larger than 255 bytes used improperly.
-136 54005 Sort key length is greater than 4000 bytes.
-137 54006 Concatenated string is too large; maximum is 32,767 for character or 16,382 for graphic.
-138 22011 The second or third operator of the SUBSTR column function is invalid.
-142 42612 Unsupported SQL statement. The statement might be valid in another RDBMS, or the statement might be valid in another context (for example, VALUES can only appear inside a trigger).
-144 58003 Named section number is invalid.
-147 42809 A source function cannot be altered. To change the source function, it must be dropped and recreated.
-148 42809 The RENAME or ALTER cannot be executed. RENAME cannot be used to rename a view or an active RLST table; ALTER cannot be used to alter the column length because the column participates in RI, a user exit, a global temporary table, or a table with DATA CAPTURE CHANGES on.
-150 42807 Invalid view update requested or a transition table was specified in an INSERT, UPDATE, or DELETE statement during a triggered action.
-151 42808 Invalid column update requested; trying to update either a non-updateable view column, a DB2 Catalog table column, or a ROWID column.
-152 42809 DROP CHECK tried to drop a referential constraint; or DROP FOREIGN KEY tried to drop a check constraint.
-153 42908 Invalid view creation required; must provide a name for an unnamed or duplicate column listed in the select list.
-154 42909 Cannot create a view using UNION, UNION ALL, or a remote table.
-156 42809 It is invalid to create an index on a view or specify an object other than a table on the ALTER TABLE, CREATE TRIGGER, DROP TABLE, or LOCK TABLE statements.
-157 42810 Must specify a table name on the FOREIGN KEY clause.
-158 42811 View columns do not match columns in the select list.
-159 42809 Invalid DROP or COMMENT ON statement.
-160 42813 WITH CHECK OPTION invalid for this view.
-161 44000 The WITH CHECK OPTION clause of the view being updated prohibits this row from being inserted or updated as specified.
-164 42502 User does not have the authority to create this view.
-170 42605 Invalid number of arguments specified for the scalar function.
-171 42815 Invalid data type length or value for the scalar function.
-173 42801 Isolation level UR cannot be specified on a cursor that is not read-only.
-180 22007 Invalid syntax for the string representation of a DATE, TIME, or TIMESTAMP value.
-181 22007 Not a valid DATE, TIME, or TIMESTAMP value.
-182 42816 Invalid date/time value in an arithmetic expression.
-183 22008 Result of arithmetic expression returns a DATE/TIME value that is not within the range of valid values.
-184 42610 Improper usage of parameter marker for DATE/TIME values.
-185 57008 No local date/time exits defined.
-186 22505 Local DATE/TIME exit changed causing invalid length for this program.
-187 22506 MVS returned invalid current date/time.
-188 22503 Invalid string representation.
-189 22522 The named coded character set ID is invalid or undefined.
-190 42837 Cannot ALTER the column as specified. Can only ALTER column length of VARCHAR columns.
-191 22504 String contains invalid mixed data.
-197 42877 Qualified column names cannot be used in an ORDER BY clause when two or more tables are unioned and then ordered.
-198 42617 Trying to issue a PREPARE or EXECUTE IMMEDIATE statement on a blank string.
-199 42601 Illegal keyword used in SQL statement.
-203 42702 Ambiguous column reference.
-204 42704 Undefined object name.
-205 42703 Invalid column name for specified table.
-206 42703 Column name not in any table referenced in the FROM clause or in the table on which the trigger is defined.
-208 42707 Cannot ORDER BY specified column because it is not in the select list.
-212 42712 The specified table name is not allowed to be used more than once in the trigger.
-214 42822 Invalid expression caused by DISTINCT and ORDER BY.
-219 42704 EXPLAIN cannot be executed because PLAN_TABLE does not exist.
-220 55002 Invalid PLAN_TABLE column encountered.
-221 55002 If any optional columns are defined for the PLAN_TABLE all of them must be defined.
-229 42708 The locale specified was not found.
-240 428B4 The PART clause of a LOCK TABLE statement is invalid.
-250 42718 Local location name is not defined.
-251 42602 Invalid token.
-300 22024 String in host variable or parameter is not null-terminated.
-301 42895 Invalid host variable data type.
-302 22001 The value of an input variable is invalid for the specified column.
  22003 The value of an input variable is too large for the specified column.
-303 42806 Value cannot be assigned because of incompatible data types.
-304 22003 Value cannot be assigned because it is out of range.
-305 22002 Null indicator variable is missing.
-309 22512 Invalid predicate due to referenced host variable set to NULL.
-310 22023 Decimal host variable or parameter cannot contain non-decimal data.
-311 22501 Invalid length of input host variable; either negative or too large.
-312 42618 Undefined or unusable host variable.
-313 07001 Number of host variables does not equal number of parameter markers.
-314 42714 Ambiguous host variable reference.
-327 22525 Cannot INSERT row outside the bounds of the last partition key range.
-330 22021 String cannot be translated successfully.
-331 22021 String cannot be assigned to a host variable because of unsuccessful translation.
-332 57017 Translation not defined for the two named coded character set IDs.
-333 56010 Subtype invalid causing translation to fail.
-338 42972 Invalid ON clause; must refer to joined columns.
-339 56082 Access to DB2 V2.2 subsystem was denied because ASCII to EBCDIC translation cannot occur.
-350 42962 Invalid large object specification.
-351 56084 Unsupported data type in SELECT list.
-352 56084 Unsupported data type in input list.
-355 42993 LOB column is too large to be logged.
-372 428C1 Only one ROWID column per table is permitted.
-390 42887 The specified function is not valid in this context.
-392 42855 The SQLDA for the specified cursor was improperly changed since the previous FETCH.
-396 38505 Attempted to execute SQL statement during final call processing.
-397 428D3 Improperly specified GENERATED on a column that is not a ROWID data type.
-398 428D2 LOCATOR was requested for a host variable that is not a LOB.
-399 22511 Invalid value specified for ROWID column in the INSERT statement.
-400 54027 Cannot define more than 100 user-defined indexes in the DB2 Catalog.
-401 42818 The operands of an arithmetic or comparison operator are not compatible.
-402 42819 Arithmetic function cannot be applied to character or date/time data.
-404 22001 The SQL statement specified a string that is too long.
-405 42820 Numeric literal is out of range.
-406 22003 A calculated or derived numeric value is out of range.
-407 23502 Cannot insert a null value into a column that is defined as NOT NULL.
-408 42821 Value cannot be inserted or updated because it is incompatible with the column's data type.
-409 42607 COUNT function specified invalid operand.
-410 42820 Floating point literal longer than maximum allowable length of 30 characters.
-411 56040 Invalid CURRENT SQLID usage.
-412 42823 Multiple columns encountered in the select list of a subquery.
-413 22003 Overflow condition when converting a numeric data type.
-414 42824 The LIKE predicate cannot operate on columns defined with a numeric or date/time data type.
-415 42825 The select lists specified for the UNION operation are not union-compatible.
-416 42907 Long string columns are not allowed in SQL statements containing the UNION operator.
-417 42609 Two parameter markers specified as operands on both sides of the same predicate.
-418 42610 Invalid usage of parameter markers.
-419 42911 Invalid decimal division.
-420 22018 Character string argument value did not conform to the function's requirements.
-421 42826 Same number of columns not supplied in the select lists for a UNION operation.
-423 0F001 Invalid value specified for the LOB or result set locator.
-426 2D528 COMMIT not permitted for an application server where updates are not permitted.
-427 2D529 ROLLBACK not permitted for an application server where updates are not permitted.
-430 38503 Error encountered within a user-defined function or stored procedure.
-433 22001 Specified value is too long.
-435 428B3 Invalid application-defined SQLSTATE.
-438 xxxxx Error raised by the application using the RAISE_ERROR function.
-440 42884 Number of parameters in the parameter list for a stored procedure or user-defined function does not match the number expected.
-441 42601 Improper usage of DISTINCT or ALL in combination with a scalar function.
-443 42601 Error SQLSTATE returned by the specified external function.
-444 42724 Program associated with the called stored procedure or user-defined function could not be found.
-449 42878 The EXTERNAL NAME clause is improperly missing from the CREATE or ALTER statement for the stored procedure or user-defined function.
-450 39501 The stored procedure or user-defined function overwrote storage beyond a parameter's declared length.
-451 42815 Improper data type specified in CREATE FUNCTION.
-453 42880 Invalid RETURNS clause in user-defined function.
-454 42723 The signature of the function specified matches a signature of another function that already exists.
-455 42882 Schema names do not match.
-456 42710 The specific name of the user-defined function already exists.
-457 42939 The user-defined function or user-defined type is attempting to use the name of a system-defined function or type.
-458 42883 Function not found.
-463 39001 Invalid SQLSTATE returned by the specified external routine.
-469 42886 Host variable must be provided on the CALL statement for parameters defined as OUT or INOUT.
-470 39002 Null parameter specified but the routine does not support NULLs.
-471 55023 Stored procedure or user-defined function failed; reason code provided.
-472 24517 Cursor was left open by the external function program.
-473 42918 Cannot name a user-defined data type the same as a system-defined data type.
-475 42866 The result type is not castable to the RETURNS type.
-476 42725 The function is not unique within its schema.
-478 42893 Cannot DROP or REVOKE the specified object because another object is dependent on it.
-480 51030 DESCRIBE PROCEDURE and ASSOCIATE LOCATORS cannot be issued until the stored procedure has been CALLed.
-482 51030 Stored procedure returned no locators.
-483 42885 Number of parameters in the CREATE FUNCTION statement does not match the number of parameters in the source function.
-487 38001 The specified stored procedure or user-defined function was created with the NO SQL option, but it is trying to issue an SQL statement.
-491 42601 The CREATE FUNCTION statement is invalid because it does not have a RETURNS clause, or because it does not specify a valid SOURCE or EXTERNAL clause.
-492 42879 The specified parameter number of the specified function is in error.
-495 57051 The estimated processor cost of the statement exceeds resource limit.
-496 51033 Statement cannot be executed because the current server is different than the server that called a stored procedure
-497 54041 Named database exceeded the limit of 32,767 OBIDs, or the CREATE DATABASE statement causes the limit of 32,511 DBIDs to be reached.
-499 24516 Named cursor already assigned to a result set from named stored procedure.
-500 24501 A WITH HOLD cursor was closed because the connection was destroyed.
-501 24501 Must open a cursor before attempting to fetch from it or close it.
-502 24502 Cannot open a cursor twice without first closing it.
-503 42912 Column cannot be updated because it was not specified in the FOR UPDATE OF clause of the cursor from which it was fetched.
-504 34000 Cannot reference cursor because it is not defined to the program.
-507 24501 Must open a cursor before attempting to update or delete WHERE CURRENT OF.
-508 24504 Cannot update or delete because the referenced cursor is not currently positioned on a data row.
-509 42827 Cannot update from a different table than the one specified on the cursor referenced by the WHERE CURRENT OF clause.
-510 42828 Table or view cannot be modified as requested.
-511 42829 FOR UPDATE OF is invalid for non-modifiable tables or views.
-512 56023 Invalid reference to a remote object.
-513 42924 An alias cannot be defined on another alias.
-514 26501 Cursor has not been prepared.
-516 26501 Describe attempted for an unprepared SQL statement.
-517 07005 Cursor is invalid because the SQL statement has not yet been prepared.
-518 07003 Execute attempted for an unprepared SQL statement.
-519 24506 Cursor cannot be open when issuing a prepare statement for its SQL statement.
-525 51015 Cannot execute SQL statement within named package because it was invalid at bind time.
-526 42995 Global temporary table cannot be used in the given context.
相关文章
  • DB2 Error Messages (SQLCODE, SQLSTATE) 2011-04-19

    SQLCODE SQLSTATE Description 000 00000 The SQL statement finished successfully. 01xxx The SQL statement finished successfully, but with a warning. +012 01545 The unqualified column name was interpreted as a correlated reference. +098 01568 A dynamic

  • DB2 Error Code Complete - SQLSTATE Message 2011-01-11

    http://space.itpub.net/8231934/viewspace-584634 http://www.cnblogs.com/bayker/archive/2009/09/01/1558167.html http://luoyahu.javaeye.com/blog/419021 ================================================== ============ DB2 error code / SQL return code info

  • DB2错误信息SQLCODE SQLSTATE (按sqlcode排序) 2012-10-29

    转完发现这里有:http://my.codeweblog.com/u/265431/blog/73325 为@红薯节省点存储空间..

  • (Reproduced) DB2 error code complete 2010-12-07

    DB2 error codes / SQL return code information control Link in COBOL DB2, the DB2 error message, if you do not know what is the meaning of the code, you can use this information to find, Of course, you can also directly in the db2 command line, enter:

  • DB2 error code explanation 2010-04-02

    DB2 SQLSTATE message anomalous 2008-03-31 13:17 SQLSTATE message SQLSTATE and their meanings are listed in this section. SQLSTATE code is grouped by type; for sub-code, see the corresponding table. Table 2. SQLSTATE class code class code means to obt

  • db2 error code information 2010-12-02

    This section lists the SQLSTATE SQLSTATE messages and their meanings. SQLSTATE codes are grouped by type; for sub-code, see the corresponding table. Table 2. SQLSTATE class code to get the meaning of sub-class code code See ... 00 Table 3 fully succe

  • DB2 Error Message Summary 2010-06-01

    SQLCODE SQLSTATE Help 000 00000 SQL statement completed successfully 01xxx SQL statement completed successfully, but warning +012 01 545 columns were not qualified to be interpreted as a reference to the relationship between +098 01 568 dynamic SQL s

  • DB2 error message prompts Daquan 2010-09-21

    db2 error prompts confusing, it is painful, after some search, finally found a very close and the dictionary type table, sharing in the hope that help! The other provides a pdf file for easy download save! SQLCODE SQLSTATE Help 000 00000 SQL statemen

  • (Reprinted) DB2 Error Code Complete 2010-12-07

    DB2 error code / SQL return code information control Links with COBOL DB2, the DB2 error message appears when the code if you do not know what that means, you can use this information to find, You can also directly in the db2 command line, enter: db2

  • DB2 error message telling you Daquan 2010-09-21

    db2 error prompts confusing, it is painful, after some search, finally found a very close class with a dictionary table, sharing in the hope that help! The other provides a pdf file for easy download and save! SQLCODE SQLSTATE Description 000 00000 S

  • DB2 error message summary-SQL CODE and SQL State-related 2011-03-08

    Operation database process, encountered many problems, many of which are related to SQL CODE and SQL State, and now a complete error message and SQLCODE and SQLState interpreted as related to the following description, a reference to yourself, find o

  • Oracle ADF 100 the exception of Business Components Error Messages 2010-03-22

    Oracle ADF Business Components Error Messages The prefix "JBO-" signifies that the following messages were generated by Oracle ADF Business Components. All messages are listed in order by the message code number. Each error message contains an e

  • struts2 tags using <s:filederror/> detailed error messages output format control 2010-07-07

    Keyword: struts2 tag fielderror error message format Feelings: do early in the project, get a 500 error page is always reported, but the background did not have any output error messages, it is depressed, The last check, the original struts were in t

  • How to customize the Struts2 form validation error messages display format / style 2010-07-12

    How to customize the Struts2 form validation error messages display format / style 2010-07-01 11:01 How to customize the Struts2 form validation error messages display format / style (S: fielderror, wrap, black spots) The previous period of time to l

  • DB2 error message corresponding to coding 2010-09-26

    Recent projects use DB2 database, DB2 database, an exception is thrown the error code, I hope the DB2 error message corresponding to coding to help friends in need.

  • [Serial] 45 habits of good programmers of 37 - to provide useful error messages 2009-12-25

    Provide useful error messages - Efficient programmers accustomed to the habit 37 45 "Do not scare the user, and threaten the programmer does not work. To provide them with clean error message. To use a similar 'user error replace and continue."

  • DB2 error message corresponding to the coding 2010-09-26

    Recent projects use the DB2 database, DB2 database is throwing an exception when an error code, hope this DB2 error message corresponding to the coding on the need to help a friend.

  • Linux Deploy Rails3 with Ruby1.9.2 (5) Fix the Error Messages 2011-09-03

    Linux Deploy Rails3 with Ruby1.9.2 (5) Fix the Error Messages 1. Sprockets:: Environment # path is deprecated we have 2 ways to solve this, it is harmless warning message one way is to upgrade our rails from rc5 to rc8. > Gem install rails-v = 3.1.0.

  • MySQL Replication Slave ignore any error messages (slave-skip-errors) 2011-07-01

    Slave in MySQL Replication to operate under normal conditions are good, but there is an error in the Master / disk full or other unexpected circumstances, will result in Slave will be some errors occur, such as: MySQL Replication appear Duplicate Key

  • On Window 7 to install DB2 error summarize 2013-08-27

    1 DB2JAVIT:RC=9505 Reason: The reason for this error is because the user who start the DB2 does not have the privilege to access the files in the installation directory duo to the system security feature. Solution: Add the user id to the db2admins or