Previous Topic: -38 - DB2 TRANSPARENCY OPTION IS NOT INSTALLEDNext Topic: -40 - CONSTRAINT AUTO-REBIND IN PROGRESS. PLEASE TRY AGAIN.


-39 - NEGATIVE RESULT FOR UNSIGNED DECIMAL TARGET

Reason:

An attempt was made to store a negative decimal value into an unsigned decimal target.

The SQLSTATE that equates to this SQL return code is 22S01.

Action:

Check host variables to be sure an unsigned decimal is not being used inappropriately. Check and adjust as necessary data values being used in computations, including negative decimal values already stored in signed decimal columns of base tables. Check whether you are attempting to insert a negative value into an unsigned decimal base table column.