![]() |
|
![]() |
![]() |
Archives of the TeradataForumMessage Posted: Wed, 25 Jul 2007 @ 16:09:11 GMT
Hi, I like to look at the statistic values. In the past i used that huge query from Dieter Noeth, you will find it here, www.teradataforum.com/teradata/20040618_202707.htm 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 Dani
| ||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||