View previous topic :: View next topic
|
Author |
Message |
bhaskar_kanteti
Active User
Joined: 01 Feb 2007 Posts: 123 Location: Hyderabad
|
|
|
|
Hi,
In my STORED PROC i had fetch query as follows:
Code: |
EXEC SQL
DECLARE CSR1 CURSOR WITH RETURN FOR
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. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
you might look at the scalar built-in function MULTIPLY_ALT. It might apply. |
|
Back to top |
|
|
bhaskar_kanteti
Active User
Joined: 01 Feb 2007 Posts: 123 Location: Hyderabad
|
|
|
|
Hi Dick Brenholtz,
MULTIPLY_ALT worked for my requirement.
Thank you so much. |
|
Back to top |
|
|
|