26 CODES
-805NEGATIVE SQLCODESQLSTATE 51002Db2 could not find a package matching the program in any collection the plan searches.-811NEGATIVE SQLCODESQLSTATE 21000A singleton SELECT INTO or a scalar subquery found more than one row.-803NEGATIVE SQLCODESQLSTATE 23505An INSERT or UPDATE would create two rows with the same value in a unique index.-911NEGATIVE SQLCODESQLSTATE 40001The unit of work was rolled back because it was chosen as the victim of a deadlock or it waited too long for a lock (timeout).-904NEGATIVE SQLCODESQLSTATE 57011Db2 could not use an object or resource, often a table space in a restricted state.-551NEGATIVE SQLCODESQLSTATE 42501The authorization ID has no privilege for that operation on that object.-818NEGATIVE SQLCODESQLSTATE 51003The program that is running and the package it uses were not made by the same precompile.-532NEGATIVE SQLCODESQLSTATE 23504Db2 refused to delete a parent row because rows in another table still point at it and the foreign key's delete rule does not allow it.-180NEGATIVE SQLCODESQLSTATE 22007A date, time or timestamp string had the wrong length or format, so Db2 could not read it as a datetime value.-302NEGATIVE SQLCODESQLSTATE 22001 or 22003An input host variable or parameter held a value that is invalid or too large for its target column, often bad packed-decimal data or a string that is too long.-530NEGATIVE SQLCODESQLSTATE 23503An INSERT, UPDATE or MERGE set a foreign key to a value that has no matching parent row, so the referential constraint was violated.-913NEGATIVE SQLCODESQLSTATE 57033The statement failed because of a deadlock or timeout, but Db2 did not roll back the unit of work; the program must commit or roll back itself.-181NEGATIVE SQLCODESQLSTATE 22007A date, time or timestamp string was in a valid format but held an impossible value, such as month 13 or 31 April.-303NEGATIVE SQLCODESQLSTATE 42806A value could not be assigned to an output host variable because the data types are not compatible, for example a character column fetched into a numeric field.-923NEGATIVE SQLCODESQLSTATE 57015The program could not connect to Db2: Db2 is down or restricted, the CICS attachment is not up, or the plan or a needed resource could not be allocated.-924NEGATIVE SQLCODESQLSTATE 58006The connection to Db2 failed because of an unexpected internal error in the connection; the function, return and reason codes give the detail.-603NEGATIVE SQLCODESQLSTATE 23515CREATE UNIQUE INDEX failed because the table already contains rows with duplicate values in the index columns.-30040NEGATIVE SQLCODESQLSTATE 57012A statement sent to a remote Db2 failed because a resource other than the database (a non-RDB resource) was not available; the connection was dropped.+100POSITIVE SQLCODE (WARNING)SQLSTATE 02000No row was found: a FETCH reached the end, a SELECT INTO found nothing, or an UPDATE or DELETE matched no rows.+304POSITIVE SQLCODE (WARNING)SQLSTATE 01515A fetched value did not fit the host variable's data type, so Db2 returned null for it (indicator -2) and carried on.+802POSITIVE SQLCODE (WARNING)SQLSTATE 01519An arithmetic error such as overflow or division by zero happened in a SELECT expression; Db2 returned null for that value (indicator -2) and continued.+204POSITIVE SQLCODE (WARNING)SQLSTATE 01532At bind time a table, view or other object named in the SQL did not exist; the package was still built but the statement will be bound at run time.+206POSITIVE SQLCODE (WARNING)SQLSTATE 01533At bind time a column named in the SQL was not found in the tables the statement uses; the statement will be bound at run time.+162POSITIVE SQLCODE (WARNING)SQLSTATE 01514An ALTER TABLE added a constraint and Db2 put the table space into CHECK-pending status until the existing data is checked.+551POSITIVE SQLCODE (WARNING)SQLSTATE 01548At bind time the authorization ID did not have the privilege needed for an operation on an object; the statement will be checked again at run time.+445POSITIVE SQLCODE (WARNING)SQLSTATE 01004A value was cut short when Db2 cast it to a shorter data type, for example by CAST, CHAR or VARCHAR.