Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 06 Jan 2003 @ 09:05:41 GMT


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


Subj:   Number overflow occured during computation
 
From:   Anonymous

Hello all,

The following is the query which gives me the error message in the subject. If I cast anyone of these as dec(15,1) I am losing data accuracy. There are 200 thousand rows in my table.

Can anybody suggest a work around to get the accurate result?

select
        l_abcd,
        l_efgh,
        sum(cast(l_ijkl as decimal(15,2)) * (1 - cast(l_mnop as decimal
(15,2))) * (1 + cast(l_qrst as decimal(15,2)))) as sum_ofcol,
from
        TABLE01
where
        l_uvwx <= date '1996-10-11' - interval '45' day
group by
        l_abcd,
        l_efgh
order by
        l_abcd,
        l_efgh;

Thanks all

Anonymous



     
  <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: 27 Dec 2016