Tag: DB2 Errors

DB2 Error Code – -613 the primary key or a unique constraint is too long or has too many columns

DB2 Error Code – -910 the sql statement cannot access an object on which a drop or alter is pending

DB2 Error Code – -502 the cursor identified in an open statement is already open

DB2 Error Code – -604 a column definition specifies an invalid length, precision, or scale attribute

DB2 Error Code – -811 the result of an embedded select statement is a table of more than one row, or the result of the subquery of a basic predicate is more than one value

DB2 Error Code – -927 the langrage interface was called when the connecting environment was not established. the program should be invoked under the dsn command

DB2 Error Code – -421 the operands of a union or union all do not have the same number of columns

DB2 Error Code – -819 the view cannot be processed because the length of its parse tree in the catalog is zero

DB2 Error Code – -208 the order by clause is invalid because column name is not part of the result table

DB2 Error Code – -115 a predicate is invalid because the comparison operator operator is followed by a parenthesized list or by any or all without a subquery

DB2 Error Code – -207 the order by clause is invalid because it includes a column name but it applies to the result of a union or union all

DB2 Error Code – -911 the current unit of work has been rolled back due to deadlock or timeout.� reason reason code, type of resource resource type, and resource name resource name

DB2 Error Code – -638 table table name cannot be created because column definition is missing

DB2 Error Code – -601 the name of the object to be created is identical to the existing name name of the object type obj type

DB2 Error Code – +100 row not found for fetch, update or delete, or the result of a query is an empty table

DB2 Error Code – -503 a column cannot be updated because it is not identified in the update clause of the select statement of the cursor

DB2 Error Code – -923 connection not established

DB2 Error Code – -518 the execute statement does not identify a valid prepared statement

DB2 Error Code – -905 unsuccessful execution due to resource limit being exceeded,resource name = resource name limit = limit amount1 cpu seconds (limit amount2 service units) derived from limit source

DB2 Error Code – -198 the operand of the prepare or execute immediate statement is blank or empty