Archives of the TeradataForum

Message Posted: Wed, 25 Jul 2007 @ 16:09:11 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>