Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   View statistic values
From:   Frei Daniel


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


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016