Archives of the TeradataForum
Message Posted: Wed, 25 Jul 2007 @ 16:09:11 GMT
I like to look at the statistic values. In the past i used that huge query from Dieter Noeth, you will find it here,
This works fine on our old hardware, but now we have migrated to V2R6.2 on a Linux 64bit. I always get the error message 2616: Numeric overflow occurred during computation.
In my opinion there is e problem with the following callculation:
(-1**(NumValuesw1 / 32768)) * (2**((NumValuesw1 / 16 mod 2048) - 1023)) * (1 + ((NumValuesw1 mod 16) * 2**-4) + (NumValuesw2 * 2**-20) + (NumValuesw3 * 2**-36) + (NumValuesw4 * 2**-52)) (decimal(18,0)) AS NumValues,
Does anyone know how to correct it?
Does i chage some numbers that it works with 64bit?
Thank for your help
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|