DB2 Error Messages (SQLCODE, SQLSTATE)

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. 
[phone] No rows found to satisfy the SQL statement. 
[phone] Update to a table defined using DATA CAPTURE was not signaled to originating subsystem. (DPROP) 
[phone] The SUBPAGES clause was specified (and ignored) for a Type 2 index. 
[phone] The number of values being inserted does not equal the number of columns in the table being inserted to. 
[phone] Named tablespace placed in check pending status. 
[phone] The named qualified column was resolved using a non-unique name. 
[phone] Named object is not defined to DB2. 
[phone] Named column does not exist in any table named in the SQL statement. 
[phone] EXPLAIN cannot be executed for the SQL statement as it references a remote object. 
[phone] The named PLAN_TABLE does not exist. 
[phone] Improperly defined PLAN_TABLE; check definition of named column. 
[phone] The value of SQLN in the SQLDA should be at least as large as the number of columns that are being described. 
[phone] At least one of the columns being described is a distinct type, so additional space is required for extended SQLVAR entries. 
[phone] At least one of the columns being described is a LOB, so additional space is required for extended SQLVAR entries. 
[phone] At least one of the columns being described is a distinct type, so additional space is required for extended SQLVAR entries. 
[phone] Value cannot be assigned to host variable because it is out of range for the data type. 
[phone] String cannot be translated so it has been assigned to NULL. 
[phone] Character conversion problem may exist due to connection to a DB2 V2.2 subsystem. 
[phone] Optimizer "hints" used to select the access path. 
[phone] Invalid optimizer "hints" specified; reason code specifies why. Optimizer "hints" were ignored. 
[phone] Unknown location. 
[phone] CREATE ALIAS object does not exist locally. 
[phone] The specified feature will not be supported in future releases of DB2. IBM recommends that you stop using this feature. 
[phone] Value has been truncated by a CAST function. 
+462 01Hxx Warning issued by user-defined function or stored procedure. 
[phone] Named stored procedure exceeded the limit on the number of query results sets it can return. 
[phone] Specifies the number of query results sets returned by the named stored procedure. Successful completion. 
[phone] Number of results sets returned by a stored procedure exceeds the number of results set locators as specified by the ASSOCIATE LOCATORS statement. 
[phone] Warning issued because the cost estimate for the dynamic SQL exceeds the warning threshold value specified in the RLST. 
[phone] A positioned update of a primary key or a delete from a table with a self-referencing constraint was requested. 
[phone] Named foreign key is a duplicate referential constraint. 
[phone] Named authorization ID lacks authority to perform the named operation on the named DB2 object. 
[phone] Named authorization ID lacks authority to perform the named operation. 
[phone] Already granted to PUBLIC so WITH GRANT OPTION not applicable. 
[phone] PUBLIC AT ALL LOCATIONS not valid for ALTER. REFERENCES, INDEX, and TRIGGER privileges. 
[phone] One or more of the privileges was ignored because the GRANTEE already possesses that privilege. 
[phone] Schema name is specified more than once. 
[phone] Comparison functions are not created for long string data types (BLOB, CLOB, and DBCLOB). 
[phone] 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. 
[phone] Table definition marked incomplete because primary key index was dropped. 
[phone] Index to enforce UNIQUE constraint has been dropped; uniqueness no longer enforced. 
[phone] WHERE NOT NULL was ignored because the key for the index being created cannot contain NULLs. 
[phone] Cannot alter or create the named table as a dependent table. 
[phone] Partitioned index for the named table in the named partitioned tablespace has not been created yet, so it is unavailable. 
[phone] Specific and non-specific volume IDs specified to the CREATE or ALTER STOGROUP statement; will not be supported in later DB2 releases (post V6). 
[phone] Cannot specify SUBPAGES clause when creating a catalog index; SUBPAGES will be ignored and default to 1. 
[phone] Limit key for the partitioning index exceeds the maximum value. 
[phone] The change to the named object may require like changes for the objects in read-only systems. 
[phone] A special register that does not exist is referenced in the SET statement. The SET request is ignored. 
[phone] Data exception error caused by data overflow or divide exception. 
[phone] ISOLATION(RR) conflicts with LOCKSIZE PAGE. 
[phone] Overflow may result due to decimal multiplication. 
[phone] Connection successful, but only SBCS will be supported. 
[phone] Type 1 indexes where SUBPAGES does not equal 1 cannot become group bufferpool dependent in a data sharing environment. 
[phone] The GBPCACHE specification is ignored because the specified bufferpool does not allow caching. 
[phone] Optimizer "hints" cannot be specified because the DB2 subsystem parameter disabling "hints" has been activated. 
[phone] 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.