SELECT DISTINCT
DCLGEN1.BRAND
,(CASE
WHEN DCLGEN1.ACCOUNT_TYPE = 'XX' THEN
DCLGEN2.AMOUNT
ELSE
(CASE
WHEN(DCLGEN1.AMOUNT1 + DCLGEN1.AMOUNT2
>= 0
THEN 0
ELSE
((DCLGEN1.AMOUNT1 + DCLGEN1.AMOUNT2)
*-1.0)
END)END) AS AMOUNT
.............
In the above sql there is an arthematic calculation as
(DCLGEN1.AMOUNT1 + DCLGEN1.AMOUNT2) * -1.0
When we bind the element i am getting the following warning.
Code:
DSNX104I -DOA1 BIND SQL WARNING
USING GRP AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=ZKCAFQ07
STATEMENT=152
THE RESULT OF DECIMAL MULTIPLICATION
MAY CAUSE OVERFLOW
What changes to be done for this arthematic calculation inorder not to get this warning.
