+364 DECFLOAT EXCEPTION exception-type HAS OCCURRED DURING operation-type OPERATION, POSITION position-number
Explanation
The exception error exception-type occurred while performing an ADDITION, SUBTRACTION, MULTIPLICATION, DIVISION, NEGATION, or BUILT-IN FUNCTION operation on a field whose data type is DECFLOAT. The error occurred while processing an arithmetic expression. If the error occurred in the SELECT list of an outer SELECT statement, position in the select list is denoted by position-number. If not, position number is 0. The possible exception types are UNDERFLOW, OVERFLOW, INEXACT, INVALID OPERATION, DIVISION BY ZERO, or SUBNORMAL. 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®.
Any of the exceptions or overflows can occur during the processing of a built-in function. If operation-type is FUNCTION, then the error occurred while processing either an input, intermediate, or final value. The cause could be that the value of a parameter is out of range.
Note: Parts of exception-type, operation-type, and position-number might or might not be returned in SQLCA, depending upon when the error was detected.
System action
The resulting data proceeds according to IEEE 754r rules. Execution of the statement continues. If the statement is cursor controlled, then the cursor will remain open.
Programmer response
Examine the expression for which the warning occurred to see if 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 that the error occurred. See the explanation of SQLCODE -405 for allowed ranges of numeric data types.
SQLSTATE
0168C if INEXACT
0168D if INVALID OPERATION
0168E if UNDERFLOW,OVERFLOW
0168F if DIVISION BY ZERO
0168G if SUBNORMAL