Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 29 Aug 2005 @ 12:16:11 GMT


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


Subj:   Re: Problem with with Decimal field in Fast Export
 
From:   Victor Sokovin

  I have tried casting to a character field but it changes the result to:  


          >  1.85460621446000E 007
          >  1.25000000000000E 002
          >  3.27500000000000E 002
          >  3.23950000000000E 003

Try to CAST the SUM first to DECIMAL(m,n) (m and n large enough to accommodate the sum and avoid numeric overflows!) and only then to CHAR. What you see now is the default FLOAT format for the SUM. I think FLOAT had been chosen as default to address potential overflow issues with sums.


Regards,

Victor



     
  <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: 23 Jun 2019