Overflow error

[mp3909]

In my database I have this value 1,200,000,000 which is stored as VARCHAR (256).
In Cognos report, this value is firstly converted to INTEGER using the CAST function and then it is multiplied by 5 ---> all stored in data item 1.

Then in another data item let's say data item 2 you take data item 1 and divide it by 4.

Now when I run my Cognos report, it fails and gives an error saying "UDA-EE-0065 Overflow occured on an "integer mul" operation".

Can someone please advise me how I can fix this?

Thank You

[Christian85]

Hi,

integer has a limited size - probably 2,147,483,647 in your case. You need to choose another data type, e.g. BIGINT. That should solve your issue.


Regards

Christian

[mp3909]

Thank you.
Your suggestion solved my issue.