| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Esql Error: Overflow calculating '%1 + or - %2' |
« View previous topic :: View next topic » |
| Author |
Message
|
| ryzor |
 Posted: Fri Feb 27, 2004 2:55 am Post subject: Esql Error: Overflow calculating '%1 + or - %2' |
 |
|
Apprentice
Joined: 31 Dec 2001
Posts: 42
|
Hi,
I'm trying to remove vat from a vat inclusive variable
i.e
DECLARE amt decimal;
DECLARE amtVat1 decimal;
DECLARE amtVat2 decimal;
SET amtVat2 = amt - ceil(((amt * 100) / 114));
i get the following error: ImbDecimal addSubtract(const ImbDecimal &left, const ImbDecimal &right, bool adding)
Overflow calculating '%1 + or - %2' --- i tried using float datatypes and got the same error.
is there an easier way that i can remove vat from a vat inclusive variable without geting the over flow error? please help. |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Feb 27, 2004 11:21 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
What is the value of amt?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| ryzor |
| Posted: Sun Feb 29, 2004 8:30 am Post subject: |
|
|
Apprentice
Joined: 31 Dec 2001
Posts: 42
|
| the value of amt is 48.82 |
|
| Back to top |
|
|
| EddieA |
| Posted: Wed Mar 03, 2004 8:49 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Found this in the CSD06 ReadMe:
| Quote: |
| IY46966 - ROUND FUNCTION FAILS WITH AN ARITHMETIC OVERFLOW ERROR |
Might be the problem.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
