DB2 Error Messages (Sorted by SQLCODE)
DB2 Error Messages (Sorted by SQLCODE)DB2 Error Messages (Sorted by SQLCODE)SQLCODESQLSTATEDescription00000000The SQL statement finished successfully. 01xxxThe SQL statement finished successfully, but with a warning.+01201545The unqualified column name was interpreted as a correlated reference.+09801568A dynamic SQL statement ends with a semicolon.+10002000No rows found to satisfy the SQL statement.+11001561Update to a table defined using DATA CAPTURE was not signaled to originating subsystem. (DPROP)+11101590The SUBPAGES clause was specified (and ignored) for a Type 2 index.+11701525The number of values being inserted does not equal the number of columns in the table being inserted to.+16201514Named tablespace placed in check pending status.+20301552The named qualified column was resolved using a non-unique name.+20401532Named object is not defined to DB2.+20601533Named column does not exist in any table named in the SQL statement.+21801537EXPLAIN cannot be executed for the SQL statement as it references a remote object.+21901532The named PLAN_TABLE does not exist.+22001546Improperly defined PLAN_TABLE; check definition of named column.+23601005The value of SQLN in the SQLDA should be at least as large as the number of columns that are being described.+23701594At least one of the columns being described is a distinct type, so additional space is required for extended SQLVAR entries.+23801005At least one of the columns being described is a LOB, so additional space is required for extended SQLVAR entries.+23901005At least one of the columns being described is a distinct type, so additional space is required for extended SQLVAR entries.+30401515Value cannot be assigned to host variable because it is out of range for the data type.+33101520String cannot be translated so it has been assigned to NULL.+33901569Character conversion problem may exist due to connection to a DB2 V2.2 subsystem.+39401629Optimizer "hints" used to select the access path.+39501628Invalid optimizer "hints" specified; reason code specifies why. Optimizer "hints" were ignored.+40201521Unknown location.+40301522CREATE ALIAS object does not exist locally.+43401608The specified feature will not be supported in future releases of DB2. IBM recommends that you stop using this feature.+44501004Value has been truncated by a CAST function.+46201HxxWarning issued by user-defined function or stored procedure.+46401609Named stored procedure exceeded the limit on the number of query results sets it can return.+46601610Specifies the number of query results sets returned by the named stored procedure. Successful completion.+49401614Number of results sets returned by a stored procedure exceeds the number of results set locators as specified by the ASSOCIATE LOCATORS statement.+49501616Warning issued because the cost estimate for the dynamic SQL exceeds the warning threshold value specified in the RLST.+53501591A positioned update of a primary key or a delete from a table with a self-referencing constraint was requested.+54101543Named foreign key is a duplicate referential constraint.+55101548Named authorization ID lacks authority to perform the named operation on the named DB2 object.+55201542Named authorization ID lacks authority to perform the named operation.+55801516Already granted to PUBLIC so WITH GRANT OPTION not applicable.+56101523PUBLIC AT ALL LOCATIONS not valid for ALTER. REFERENCES, INDEX, and TRIGGER privileges.+56201560One or more of the privileges was ignored because the GRANTEE already possesses that privilege.+58501625Schema name is specified more than once.+59901596Comparison functions are not created for long string data types (BLOB, CLOB, and DBCLOB).+61001566The 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.+62501518Table definition marked incomplete because primary key index was dropped.+62601529Index to enforce UNIQUE constraint has been dropped; uniqueness no longer enforced.+64501528WHERE NOT NULL was ignored because the key for the index being created cannot contain NULLs.+65001538Cannot alter or create the named table as a dependent table.+65301551Partitioned index for the named table in the named partitioned tablespace has not been created yet, so it is unavailable.+65501597Specific and non-specific volume IDs specified to the CREATE or ALTER STOGROUP statement; will not be supported in later DB2 releases (post V6).+65801600Cannot specify SUBPAGES clause when creating a catalog index; SUBPAGES will be ignored and default to 1.+66401540Limit key for the partitioning index exceeds the maximum value.+73801530The change to the named object may require like changes for the objects in read-only systems.+79901527A special register that does not exist is referenced in the SET statement. The SET request is ignored.+80201519Data exception error caused by data overflow or divide exception.+80601553ISOLATION(RR) conflicts with LOCKSIZE PAGE.+80701554Overflow may result due to decimal multiplication.+86301539Connection successful, but only SBCS will be supported.+200056094Type 1 indexes where SUBPAGES does not equal 1 cannot become group bufferpool dependent in a data sharing environment.+200201624The GBPCACHE specification is ignored because the specified bufferpool does not allow caching.+200701602Optimizer "hints" cannot be specified because the DB2 subsystem parameter disabling "hints" has been activated.+3010001558Distribution protocol error detected. Original SQLCODE and SQLSTATE provided.-00742601Illegal character in SQL statement.-01042603String constant not terminated properly; check for missing quotation marks.-02942601INTO clause required.-06042815Invalid length or scale specification for the specified data type.-08442612SQL statement cannot be executed because it is invalid for dynamic SQL or is not valid for DB2 for OS/390.-09742601Cannot use LONG VARCHAR or LONG VARGRAPHIC with CAST, or in distinct types, user-defined functions, and procedures.-10154001SQL statement exceeds an established DB2 limit; for example, too many tables, too many bytes in statement, and so on.-10254002String constant is too long.-10342604Invalid numeric literal.-10442601Illegal symbol encountered in SQL statement.-10542604Invalid character string format; usually refers to an improperly formatted graphic string.-10742622Object name is too long.-10842601Incorrect name specified for the RENAME statement; cannot use a qualifier.-10942601Invalid clause specified; for example: CREATE VIEW cannot contain an ORDER BY clause.-11042606Invalid hexadecimal literal encountered.-11142901Column function specified without a column name.-11242607Invalid column function syntax; column function cannot operate on another column function.-11342602Invalid character encountered.-11442961Location name for this statement must match the current server, but it does not.-11542601Invalid predicate encountered because comparison operator is not followed by an expression or list.-11742802Number of inserted values not equivalent to number of columns for the inserted row.-11842902Table or view is illegally named in both data modification clause (UPDATE or DELETE) and the FROM clause.-11942803Column list in HAVING clause does not match column list in the GROUP BY clause.-12042903The WHERE clause, SET clause, VALUES clause, or SET ASSIGNMENT statement is not allowed to reference a column function.-12142701A column is illegally referenced twice in an INSERT or UPDATE statement.-12242803Column function applied illegally because all columns not applied to a column function are not in the GROUP BY clause.-12342601The parameter in the specified position must be either a constant or a key word.-12542805Invalid number specified in the ORDER BY clause--number is either less than 1 or greater than the number of columns selected.-12642829An ORDER BY clause cannot be specified for an UPDATE statement.-12742905DISTINCT can only be specified once in a subselect.-12842601NULL use improperly in an SQL predicate.-12954004The SQL statement contains more than 15 tables.-13022019Escape clause must be 1 character. 22025Invalid escape pattern.-13142818The LIKE predicate can only be applied to character data.-13242824Invalid operand in LIKE clause, ESCAPE clause, LOCATE function, or POSSTR function.-13342906Invalid correlated subquery reference.-13442907Column larger than 255 bytes used improperly.-13654005Sort key length is greater than 4000 bytes.-13754006Concatenated string is too large; maximum is 32,767 for character or 16,382 for graphic.-13822011The second or third operator of the SUBSTR column function is invalid.-14242612Unsupported 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).-14458003Named section number is invalid.-14742809A source function cannot be altered. To change the source function, it must be dropped and recreated.-14842809The 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.-15042807Invalid view update requested or a transition table was specified in an INSERT, UPDATE, or DELETE statement during a triggered action.-15142808Invalid column update requested; trying to update either a non-updateable view column, a DB2 Catalog table column, or a ROWID column.-15242809DROP CHECK tried to drop a referential constraint; or DROP FOREIGN KEY tried to drop a check constraint.-15342908Invalid view creation required; must provide a name for an unnamed or duplicate column listed in the select list.-15442909Cannot create a view using UNION, UNION ALL, or a remote table.-15642809It 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.-15742810Must specify a table name on the FOREIGN KEY clause.-15842811View columns do not match columns in the select list.-15942809Invalid DROP or COMMENT ON statement.-16042813WITH CHECK OPTION invalid for this view.-16144000The WITH CHECK OPTION clause of the view being updated prohibits this row from being inserted or updated as specified.-16442502User does not have the authority to create this view.-17042605Invalid number of arguments specified for the scalar function.-17142815Invalid data type length or value for the scalar function.-17342801Isolation level UR cannot be specified on a cursor that is not read-only.-18022007Invalid syntax for the string representation of a DATE, TIME, or TIMESTAMP value.-18122007Not a valid DATE, TIME, or TIMESTAMP value.-18242816Invalid date/time value in an arithmetic expression.-18322008Result of arithmetic expression returns a DATE/TIME value that is not within the range of valid values.-18442610Improper usage of parameter marker for DATE/TIME values.-18557008No local date/time exits defined.-18622505Local DATE/TIME exit changed causing invalid length for this program.-18722506MVS returned invalid current date/time.-18822503Invalid string representation.-18922522The named coded character set ID is invalid or undefined.-19042837Cannot ALTER the column as specified. Can only ALTER column length of VARCHAR columns.-19122504String contains invalid mixed data.-19742877Qualified column names cannot be used in an ORDER BY clause when two or more tables are unioned and then ordered.-19842617Trying to issue a PREPARE or EXECUTE IMMEDIATE statement on a blank string.-19942601Illegal keyword used in SQL statement.-20342702Ambiguous column reference.-20442704Undefined object name.-20542703Invalid column name for specified table.-20642703Column name not in any table referenced in the FROM clause or in the table on which the trigger is defined.-20842707Cannot ORDER BY specified column because it is not in the select list.-21242712The specified table name is not allowed to be used more than once in the trigger.-21442822Invalid expression caused by DISTINCT and ORDER BY.-21942704EXPLAIN cannot be executed because PLAN_TABLE does not exist.-22055002Invalid PLAN_TABLE column encountered.-22155002If any optional columns are defined for the PLAN_TABLE all of them must be defined.-22942708The locale specified was not found.-240428B4The PART clause of a LOCK TABLE statement is invalid.-25042718Local location name is not defined.-25142602Invalid token.-30022024String in host variable or parameter is not null-terminated.-30142895Invalid host variable data type.-30222001The value of an input variable is invalid for the specified column. 22003The value of an input variable is too large for the specified column.-30342806Value cannot be assigned because of incompatible data types.-30422003Value cannot be assigned because it is out of range.-30522002Null indicator variable is missing.-30922512Invalid predicate due to referenced host variable set to NULL.-31022023Decimal host variable or parameter cannot contain non-decimal data.-31122501Invalid length of input host variable; either negative or too large.-31242618Undefined or unusable host variable.-31307001Number of host variables does not equal number of parameter markers.-31442714Ambiguous host variable reference.-32722525Cannot INSERT row outside the bounds of the last partition key range.-33022021String cannot be translated successfully.-33122021String cannot be assigned to a host variable because of unsuccessful translation.-33257017Translation not defined for the two named coded character set IDs.-33356010Subtype invalid causing translation to fail.-33842972Invalid ON clause; must refer to joined columns.-33956082Access to DB2 V2.2 subsystem was denied because ASCII to EBCDIC translation cannot occur.-35042962Invalid large object specification.-35156084Unsupported data type in SELECT list.-35256084Unsupported data type in input list.-35542993LOB column is too large to be logged.-372428C1Only one ROWID column per table is permitted.-39042887The specified function is not valid in this context.-39242855The SQLDA for the specified cursor was improperly changed since the previous FETCH.-39638505Attempted to execute SQL statement during final call processing.-397428D3Improperly specified GENERATED on a column that is not a ROWID data type.-398428D2LOCATOR was requested for a host variable that is not a LOB.-39922511Invalid value specified for ROWID column in the INSERT statement.-40054027Cannot define more than 100 user-defined indexes in the DB2 Catalog.-40142818The operands of an arithmetic or comparison operator are not compatible.-40242819Arithmetic function cannot be applied to character or date/time data.-40422001The SQL statement specified a string that is too long.-40542820Numeric literal is out of range.-40622003A calculated or derived numeric value is out of range.-40723502Cannot insert a null value into a column that is defined as NOT NULL.-40842821Value cannot be inserted or updated because it is incompatible with the column's data type.-40942607COUNT function specified invalid operand.-41042820Floating point literal longer than maximum allowable length of 30 characters.-41156040Invalid CURRENT SQLID usage.-41242823Multiple columns encountered in the select list of a subquery.-41322003Overflow condition when converting a numeric data type.-41442824The LIKE predicate cannot operate on columns defined with a numeric or date/time data type.-41542825The select lists specified for the UNION operation are not union-compatible.-41642907Long string columns are not allowed in SQL statements containing the UNION operator.-41742609Two parameter markers specified as operands on both sides of the same predicate.-41842610Invalid usage of parameter markers.-41942911Invalid decimal division.-42022018Character string argument value did not conform to the function's requirements.-42142826Same number of columns not supplied in the select lists for a UNION operation.-4230F001Invalid value specified for the LOB or result set locator.-4262D528COMMIT not permitted for an application server where updates are not permitted.-4272D529ROLLBACK not permitted for an application server where updates are not permitted.-43038503Error encountered within a user-defined function or stored procedure.-43322001Specified value is too long.-435428B3Invalid application-defined SQLSTATE.-438xxxxxError raised by the application using the RAISE_ERROR function.-44042884Number of parameters in the parameter list for a stored procedure or user-defined function does not match the number expected.-44142601Improper usage of DISTINCT or ALL in combination with a scalar function.-44342601Error SQLSTATE returned by the specified external function.-44442724Program associated with the called stored procedure or user-defined function could not be found.-44942878The EXTERNAL NAME clause is improperly missing from the CREATE or ALTER statement for the stored procedure or user-defined function.-45039501The stored procedure or user-defined function overwrote storage beyond a parameter's declared length.-45142815Improper data type specified in CREATE FUNCTION.-45342880Invalid RETURNS clause in user-defined function.-45442723The signature of the function specified matches a signature of another function that already exists.-45542882Schema names do not match.-45642710The specific name of the user-defined function already exists.-45742939The user-defined function or user-defined type is attempting to use the name of a system-defined function or type.-45842883Function not found.-46339001Invalid SQLSTATE returned by the specified external routine.-46942886Host variable must be provided on the CALL statement for parameters defined as OUT or INOUT.-47039002Null parameter specified but the routine does not support NULLs.-47155023Stored procedure or user-defined function failed; reason code provided.-47224517Cursor was left open by the external function program.-47342918Cannot name a user-defined data type the same as a system-defined data type.-47542866The result type is not castable to the RETURNS type.-47642725The function is not unique within its schema.-47842893Cannot DROP or REVOKE the specified object because another object is dependent on it.-48051030DESCRIBE PROCEDURE and ASSOCIATE LOCATORS cannot be issued until the stored procedure has been CALLed.-48251030Stored procedure returned no locators.-48342885Number of parameters in the CREATE FUNCTION statement does not match the number of parameters in the source function.-48738001The specified stored procedure or user-defined function was created with the NO SQL option, but it is trying to issue an SQL statement.-49142601The 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.-49242879The specified parameter number of the specified function is in error.-49557051The estimated processor cost of the statement exceeds resource limit.-49651033Statement cannot be executed because the current server is different than the server that called a stored procedure-49754041Named database exceeded the limit of 32,767 OBIDs, or the CREATE DATABASE statement causes the limit of 32,511 DBIDs to be reached.-49924516Named cursor already assigned to a result set from named stored procedure.-50024501A WITH HOLD cursor was closed because the connection was destroyed.-50124501Must open a cursor before attempting to fetch from it or close it.-50224502Cannot open a cursor twice without first closing it.-50342912Column cannot be updated because it was not specified in the FOR UPDATE OF clause of the cursor from which it was fetched.-50434000Cannot reference cursor because it is not defined to the program.-50724501Must open a cursor before attempting to update or delete WHERE CURRENT OF.-50824504Cannot update or delete because the referenced cursor is not currently positioned on a data row.-50942827Cannot update from a different table than the one specified on the cursor referenced by the WHERE CURRENT OF clause.-51042828Table or view cannot be modified as requested.-51142829FOR UPDATE OF is invalid for non-modifiable tables or views.-51256023Invalid reference to a remote object.-51342924An alias cannot be defined on another alias.-51426501Cursor has not been prepared.-51626501Describe attempted for an unprepared SQL statement.-51707005Cursor is invalid because the SQL statement has not yet been prepared.-51807003Execute attempted for an unprepared SQL statement.-51924506Cursor cannot be open when issuing a prepare statement for its SQL statement.-52551015Cannot execute SQL statement within named package because it was invalid at bind time.-52642995Global temporary table cannot be used in the given context.-530 23503Invalid foreign key value specified for the specified constraint name.-53123504As of V5, multi-row update of a parent key attempted to remove a parent key vale on which a foreign key was dependent. Prior to V5, attempting to update a primary key value when foreign keys currently exist that reference that value.-53223504Deletion violates the named referential constraint.-53321501Invalid multiple row insert; attempted to insert multiple rows into a self-referencing table.-53421502An update statement changing the value of a primary key column cannot be used to update more than one row at a time.-53521502Cannot specify WHERE CURRENT OF when deleting from a self-referencing table or updating primary key column(s). This code will be raised only by non-V5 subsystems.-53642914Invalid delete statement due to referential constraints existing for the specified table.-53742709A single column cannot appear more than once in a foreign key or primary key clause specification.-53842830Invalid foreign key; does not conform to the definition of the referenced table's primary key.-53942888Foreign key cannot be defined because the referenced table does not have a primary key.-54057001Table definition is incomplete until a unique index is created for the primary key or UNIQUE clause, or the ROWID column contains the GENERATED BY DEFAULT attribute.-54242831Nullable columns are not permitted to be included as part of a primary key.-54323511DELETE cannot occur because the table is a parent table in a referential constraint specifying the SET NULL delete rule, but the check constraint does not allow NULLs.-54423512Cannot add this check constraint using ALTER because an existing row violates the check constraint.-54523513INSERT or UPDATE caused a check constraint violation.-54642621Invalid check constraint specified in CREATE or ALTER TABLE.-54842621Invalid check constraint due to named column.-54942509Invalid SQL statement for DYNAMICRULES(BIND) plan or package.-55142501User is attempting to perform an operation on the specified object for which he is not authorized, or the table does not exist.-55242502User is attempting to perform an operation for which he is not authorized.-55342503Cannot set CURRENT SQLID because the user has not been set up to change to that ID.-55442502Cannot grant a privilege to yourself.-55542502Cannot revoke a privilege from yourself.-55642504Cannot revoke a privilege that the user does not possess.-55742852Inconsistent grant or revoke key word specified.-55856025Invalid clause or clauses specified for the grant or revoke statement.-55957002The DB2 authorization mechanism has been disabled. Grant and revoke cannot be issued.-56742501Named authorization ID lacks the authority to bind the named package.-57125000Multiple site updates are not permitted.-57342890Referential constraint cannot be defined because the named parent table does not have a unique key on the specified column.-57442894Specified default conflicts with the column definition.-57738002Tried to modify data in a user-defined function or stored procedure that was created without the MODIFIES SQL DATA option.-57938004Tried to read data in a user-defined function or stored procedure that was created without either the READS SQL DATA or MODIFIES SQL DATA option.-58042625Result expressions of a CASE expression cannot all be NULL.-58142804Incompatible data types in the result expressions of a CASE expression.-58242625Search-condition in a searched-when-clause specifies a quantified, IN, or EXISTS predicate.-58342845The specified function is invalid because it is not deterministic or may have an external action.-58542732The schema name appears more than once in the current path.-58642907The CURRENT PATH special register cannot exceeed 254 characters in length.-587428C6The list of item-references must be of the same family.-59042734The parameter name must be unique within the named stored procedure or user-defined function.-59242510Not authorized to create stored procedures or user-defined functions in WLM environment.-60142710Attempting to create (or rename) an object that already exists.-60254008Too many columns specified in the CREATE INDEX statement.-60323515Unique index cannot be created because duplicates were found.-60442611Invalid length, precision, or scale specified for the data type in a CREATE or ALTER TABLE statement.-60742832The INSERT UPDATE or DELETE statement specified cannot be issued as written against the DB2 Catalog tables.-61153088When LOCKSIZE is TABLE or TABLESPACE, LOCKMAX must 0.-61242711Duplicate column names not permitted within a single table, index, or view.-61354008The primary key or UNIQUE constraint is too long or contains too many columns.-61454008Maximum internal key length of 255 for indexes has been surpassed.-61555006Cannot drop this package because it is currently executing.-61642893The specified object cannot be dropped because other objects are dependent upon it.-61756089Type 1 index is invalid for DB2 Version 6. For previous releases, a type 1 index cannot be defined with LOCKSIZE ROW or LARGE tablespace.-61842832Requested operation not permitted for DB2 Catalog tables.-61955011DSNDB07 cannot be modified unless it has first been stopped.-62053001The specified key word is not permitted for a tablespace in DSNDB07.-62158001Duplicate DBID encountered; system problem encountered.-62256031Cannot specify FOR MIXED DATA because the mixed data option has not been installed.-62355012Cannot define more than one clustering index for a single table.-62442889Cannot define more than one primary key for a single table.-62555014A unique index is required for a table defined with a primary key.-62655015Cannot issue an ALTER statement to change PRIQTY SECQTY or ERASE unless the tablespace has first been stopped.-62755016Cannot issue an ALTER statement to change PRIQTY SECQTY or ERASE unless the tablespace has first been defined to use storage groups.-62842613The clauses specified are mutually exclusive (for example, cannot partition a segmented tablespace).-62942834SET NULL is invalid because the foreign key cannot contain null values.-63056089WHERE NOT NULL cannot be specified for Type 1 indexes.-63154008Invalid foreign key; is either longer than 254 bytes or contains more than 40 columns.-63242915The specified delete rules prohibit defining this table as a dependent of the named table.-63342915Invalid delete rule; the specified mandatory delete rule must be used.-63442915DELETE CASCADE is not allowed in this situation.-63542915The delete rule cannot be different or cannot be SET NULL.-63656016The partitioning index must be consistent in its specification of ascending or descending for the partitioning index key.-63742614Duplicate key word encountered.-63842601Missing column definition in CREATE TABLE statement.-63956027A nullable column of a foreign key with a delete rule of SET NULL cannot be a column of the key of a partitioning index.-64056089LOCKSIZE ROW cannot be specified for this tablespace because a Type 1 index is defined on a table in the tablespace.-64254021Unique constraint contains too many columns.-64354024Check constraint exceeds maximum length of 3,800 characters.-64442615Invalid value specified for key word in the SQL statement.-64655017The table cannot be created in the specified partitioned or default tablespace because the specified tablespace already contains a table.-64757003The specified bufferpool is invalid because it has not been activated.-65056090ALTER INDEX cannot be executed; reason code provided.-65154025Table object descriptor (OBD) would exceed maximum size (32KB) if the CREATE or ALTER TABLE were allowed.-65223506Violation of EDITPROC or VALIDPROC encountered.-65357004A table in a partitioned tablespace is unavailable because the partitioning index has not been created yet.-65556036STOGROUP cannot specify both specific and non-specific ("*") volumes in the volume list.-65842917The specified object cannot be dropped as attempted. The object must be dropped by dropping an associated object.-66053035Improper partitioning index specification; must define limit keys for the clustering index.-66153036Partitioning index does not specify the proper number of partitions.-66253037Attempted to create a partitioning index on a non-partitioned (segmented or simple) tablespace.-66353038Invalid number of key limit values specified for the partitioning index.-66553039Invalid PART clause specified for ALTER TABLESPACE statement.-66657005SQL statement cannot be processed because the specified function is current in progress.-66742917Cannot explicitly drop the clustering index for a partitioned tablespace; must drop the partitioned tablespace to drop index.-66856018Cannot add a column to a table defined with an EDITPROC.-66942917Cannot explicitly drop a table in a partitioned tablespace; must drop the partitioned tablespace to drop the table.-67054010The record length for the table exceeds the page size.-67153040Cannot alter the bufferpool for the specified tablespace because it would change the page size of the tablespace.-67255035DROP not allowed on named table.-67653041Only a 4KB bufferpool can be used for an index.-67757011Bufferpool expansion failed due to insufficient amount of available virtual storage.-67853045The literal specified for the limit key in the partitioning index does not conform to the data type of the key value.-67957006Cannot create the specified object because a drop is currently pending for that object.-68054011No more than 750 columns can be specified for a DB2 table.-68123507Column violates specified FIELDPROC.-68257010FIELDPROC could not be loaded.-68342842Invalid column, distinct type, function, or procedure because of incompatible clauses. For example, specifying INTEGER with the FOR BIT DATA option.-68454012The specified literal list cannot exceed 254 bytes.-68558002FIELDPROC returned an invalid field description.-68653043A column defined with a FIELDPROC cannot be compared to a column defined with a different FIELDPROC.-68753044A column cannot be compared to a column with an incompatible field type.-68858002Incorrect data returned by the FIELDPROC.-68954011Dependent table defined with too many columns.-69023508Data definition control support rejected this statement.-69157018The named registration table does not exist.-69257018The named index does not exist, but is required for the named registration table.-69355003The named column for the named registration table/index is invalid.-69457023A DROP is pending on the named registration table.-69642898The specified trigger is invalid due to improper use of correlation name or transition table name.-69742899FOR EACH statement clause specified, so OLD and NEW correlation names are not allowed; or OLD_TABLE and NEW_TABLE cannot be specified for a BEFORE trigger.-71342815The special register value specified is invalid.-71556064The named program cannot be run because it depends on features of a release of DB2 that your shop has installed but backed off.-71656065The named program was precompiled with an incorrect level for this release.-71756066BIND failed because it depends on features of a release of DB2 that your shop has installed but backed off.-71856067REBIND failed because IBMREQD column is invalid.-71942710Cannot BIND ADD a package that already exists.-72042710Cannot BIND REPLACE a package version that already exists.-72142710Consistency token must be unique for package.-72242704Bind error due because the named package does not exist.-72309000A triggered SQL statement received an error.-72454038Maximum number of cascading indirect SQL statements reached (16).-72542721Invalid value supplied to the specified special register.-72655030Cannot bind this package because of SYSPKSYSTEM entries.-72856080The specified data type cannot be used with private protocol distribution.-729429B1A stored procedure defined using COMMIT ON RETURN cannot be the target of a nested procedure CALL.-73056053Invalid referential integrity definition for a table in a read-only shared database.-73156054VSAM data set must be defined using SHAREOPTION(1,3).-73256055Read-only database defined, but the owning DB2 subsystem has not defined the tablespace or index space.-73356056Inconsistent read-only shared database definition.-73456057Once a database has been defined as ROSHARE READ, it cannot be altered to a different ROSHARE state.-73555004The database identified by the named DBID is no longer a read-only shared database.-73653014The named OBID is invalid.-73756056Cannot create an implicit tablespace under these circumstances.-73956088The specified function cannot be altered because both the ALLOW PARALLEL and MODIFIES SQL DATA clauses were specified.-74051034The specified function cannot be defined with MODIFIES SQL DATA in this way.-74155030Work file database already defined for named data sharing group member.-74253004DSNDB07 is the implicit work file database.-74657053The SQL statement in the specified trigger, stored procedure, or function violates the nesting SQL restriction.-74757054The specified table is not available until the required auxiliary tables have been created for the LOB data columns.-74854042An index already exists on the specified auxiliary table.-75042986Cannot rename the named table because it is referenced in at least one existing view or trigger.-75142987A stored procedure or user-defined function tried to execute an SQL statement that is not allowed. The DB2 thread is placed in MUST_ROLLBACK state.-7520A001Invalid CONNECT statement.-763560A1Invalid tablespace name.-764560A2The LOB tablespace must be in the same database as its associated base tablespace.-765560A3The table is not compatible with the database.-766560A4Cannot perform the requested operation on an auxiliary table.-76742626The CREATE INDEX failed because columns were specified for an index on an auxiliary table, or because columns were not specified on an index on a non-auxiliary table.-768560A5Cannot create an auxiliary table for the specified column or partition because one already exists.-76953096The specs for the CREATE AUX TABLE do not match the base table.-770530A6The specified table must have a ROWID column before it can contain a LOB column.-771428C7Invalid ROWID column specification.-79742987The CREATE TRIGGER contains unsupported syntax.-798428C9Cannot insert a value into a ROWID column defined with GENERATED ALWAYS.-80222012Exception error has occurred for the specified operation. Divide by zero. 22003Exception error has occurred for the specified operation. Other than divide by zero.-80323505Cannot insert row because it would violate the constraints of a unique index.-80407002The call parameter list for the SQLDA is in error.-80551002The DBRM or package name not found in plan.-80723509Package not enabled for the named environment and connection.-80808001The CONNECT statement is not consistent with the program's first CONNECT statement.-81121000Must use a cursor when more than one row is returned as the result of an embedded select statement.-81222508Collection-ID is blank in the CURRENT PACKAGESET; statement cannot be executed.-81542920A GROUP BY or HAVING clause is implicitly or explicitly specified in an embedded select statement or a subquery of a basic predicate.-81725000Execution of the SQL statement would result in a prohibited update to user data or the DB2 Catalog.-81851003Plan <--> load module timestamp mismatch. The DBRM in the executing plan was not created from the same precompilation as the load module.-81958004View cannot be recreated because the length of the parse tree stored in the DB2 Catalog is zero.-82058004Invalid value encountered in DB2 Catalog for this DB2 release.-82251004Invalid address encountered in the SQLDA.-84054004Too many items returned in a select list or insert list.-84208002A connection to the named location already exists.-84308003The SET CONNECTION or RELEASE statement cannot be executed because the connection does not exist.-87058026The number of host variable descriptors does not equal the number of host variables in the statement.-87251032A valid CCSID has yet to be specified for this subsystem.-87353090Cannot refer to a column defined in an ASCII table in the same SQL statement as a column defined in an EBCDIC table.-87453091The encoding scheme for the specified object does not match the encoding scheme for its tablespace.-87542988Specified operand cannot be used with ASCII data.-87653092Object cannot be created for the specified reason; reason code provided.-87753093ASCII not permitted for the database or tablespace; EBCDIC must be used.-87853094This PLAN_TABLE cannot be ASCII; EBCDIC must be used.-87953095The CREATE or ALTER statement for the specified object cannot define the column, distinct type, or parameter of a stored procedure or user-defined function parameter as MIXED DATA, GRAPHIC, VARGRAPHIC, or LONG VARGRAPHIC because the system does not have an appropriate CCSID defined for the encoding scheme specified.-90008003Application process is not connected to an application server; statement cannot be executed.-90158004Intermittent system error encountered that does not inhibit subsequent SQL statements from being executed.-90258005Internal control block pointer error; rebind required.-90457011The specified resource is unavailable.-90557014Resource limit has been exceeded.-90651005SQL statement cannot be executed because of prior error.-90823510Current Resource Limit Facility specification or Auto-Rebind system parameter does not permit the BIND, REBIND, or AUTO-REBIND.-90957007The object has been deleted.-91057007Cannot access an object for which a DROP is pending.-91140001The current unit of work has been rolled back.-91357033Unsuccessful execution caused by either a deadlock or a timeout.-91742969Bind package has failed.-91851021SQL statement cannot be executed because connection was lost.-91956045A ROLLBACK is required.-92242505Connection authorization failure. Attempting to access DB2 from TSO, CICS, or IMS, and appropriate attachment facility is inactive.-92357015Connection not established because DB2 is unavailable.-92458006DB2 internal connection error encountered; reason code provided.-9252D521The SQL COMMIT statement cannot be issued from CICS or IMS/TM.-9262D521The SQL ROLLBACK statement cannot be issued from CICS or IMS/TM.-92751006The language interface was called when the connecting environment was not established. Invoke the program using the DSN command.-92958002Data capture exit has failed. (DPROP)-93951021Rollback is required due to unrequested rollback of a remote server.-94756038SQL statement failed because update cannot be propagated. (DPROP)-94856062DDF not started; distributed operation is invalid.-95042705Location specified in the SQL statement not defined in SYSIBM.LOCATIONS.-96551021Stored procedure terminated abnormally (prior to DB2 Version 6).-98157015Attempt to execute SQL in the RRSAF when it was not in a state to allow SQL.-99157015Call attach was not able to establish an implicit connect or open to DB2.-200153089Number of host variable parameters specified for a stored procedure does not equal the expected number of parameters.-20003560A7Cannot specify GBPCACHE NONE for tablespace or index in GRECP.-20004560A88KB or 16KB bufferpool page size is invalid for a WORKFILE object.-2000554035The internal ID limit has been exceeded for the specified object type.-2000653097A LOB cannot be specified as a parameter when no WLM environment is specified.-2007053098Cannot create an auxiliary table for a non-LOB column.-2007153099Must specify the WLM environment name.-2007256052Specified authid does not possess the needed authority to perform the BIND on the trigger package.-2007342927Cannot alter the named function as specified because it is referenced in existing view definitions.-2007442939The specified object cannot be created because "SYS" is a reserved prefix.-2010056059BIND error in triggered SQL statement; SQLCODE and SQLSTATE of the error is specified.-2010156059The function failed for the specified reason code.-2010242849Cannot use the specified option in the CREATE or ALTER FUNCTION statement.-2010442856Failed attempt to alter a CCSID.-2010642945Cannot change the CCSID for the tablespace or database because of existing view references.-3000058008DRDA distribution protocol error; processing can continue.-3000257057A distributed client using DRDA chained an OPEN statement to a PREPARE, but the PREPARE received a SQLCODE +495 warning.-3002058009DRDA distribution protocol error; conversation deallocated.-3002158010DRDA distribution protocol error; processing cannot continue.-3003058013Distribution protocol violation; COMMIT unsuccessful, conversation deallocated. (AS)-3004057012Execution failed due to unavailable resource(s); processing can continue. (AS)-3004157013Execution failed due to unavailable resource(s); processing cannot successfully continue.-3005058011Execution unsuccessful; statement cannot be executed during the BIND process.-3005158012Failure caused by specific BIND process not being active. (Remote BIND)-3005242932Program preparation assumption incorrect.-3005342506Authorization failure encountered for package owner.-3006008004Authorization failure encountered for RDB.-3006108004Invalid or non-existent RDB specified.-3007058014Target subsystem does not support this command.-3007158015Target subsystem does not support this object.-3007258016Target subsystem does not support this parameter.-3007358017Target subsystem does not support this parameter value.-3007458018Reply message not supported.-3008008001SNA communication error.-3008158019TCP/IP communication error.-3008208001Communication failed due to security violation; reason code provided.-3009025000Specified operation invalid for remote execution.-3010456095Error in bind option and bind value.-3010556096The specified bind options are incompatible.
页:
[1]