HomeDB2DB2 Error Code – +802 exception error exception-type has occurred during operation-type operation on data-type data, position position-number

DB2 Error Code – +802 exception error exception-type has occurred during operation-type operation on data-type data, position position-number

In this post, you’ll learn about the error message +802 exception error exception-type has occurred during operation-type operation on data-type data, position position-number in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

+802 exception error exception-type has occurred during operation-type operation on data-type data, position position-number

Reason for the Error

The exception error ‘exception-type’ occurred while doing an ADDITION, SUBTRACTION, MULTIPLICATION, DIVISION, or NEGATION operation on a field whose ‘data-type’ is DECIMAL, FLOAT, SMALLINT, or INTEGER.� The error occurred while processing an arithmetic expression in the SELECT list of an outer SELECT statement, and the position in the select list is denoted by ‘position-number’.� The possible exception types are FIXED POINT OVERFLOW, DECIMAL OVERFLOW, DIVIDE EXCEPTION, EXPONENT OVERFLOW, and ZERO DIVIDE.� The data type displayed in the message may indicate the data type of the temporary internal copy of the data, which may differ from the actual column or literal data type due to conversions by DB2.A fixed point overflow can occur during any arithmetic operation on either INTEGER or SMALLINT fields.A decimal overflow exception can occur when one or more non-zero digits are lost because the destination field in any decimal operation is too short to contain the result.

Solution

Examine the expression for which the warning occurred to see if the cause (or the likely cause) of the problem can be determined.� The problem may be data-dependent, in which case it will be necessary to examine the data that was being processed at the time the error occurred. Check arithmetic operation for divide by zero or result to exceed size of host variable.

Share:

Leave a Reply

You May Also Like

In this post, you’ll learn about the error message -952 processing was interrupted by a cancel request from a client...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -927 the langrage interface was called when the connecting environment was...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -926 rollback not valid in ims/vs or cics environment in the...
  • DB2
  • November 21, 2022