An exception error has occurred in the processing of an SQL arithmetic function or arithmetic expression. The exception error occurred in one of the following areas:
In the SELECT list of an SQL SELECT statement. In the search condition of a SELECT, UPDATE, MERGE, or DELETE statement. In the SET clause of the UPDATE operation. During the evaluation of an aggregate function. Parts of exception-type, operation-type, data-type, and position-number might not be returned to the SQL communication area, depending on where the error was detected.
exception-type: Indicates the type of error. Possible values for exception-type are:
FIXED POINT OVERFLOW
OUT OF RANGE
operation-type: Indicates the operation that was being performed at the time of the error. Possible operation-type includes the following arithmetic operations:
operation-type might also be one of the following operations:
Examine the SQL statement to see if the cause of the problem can be determined. The problem might be data-dependent, in which case it will be necessary to examine the data that was being processed at the time the error occurred.
If the arithmetic expression in error was within the SELECT list of the outer SELECT statement, it is advisable to include an indicator variable for all expressions in the SELECT list. This allows processing to continue so that non-error column and expression values can be returned.