Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   View statistic values
 
From:   Frei Daniel

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023