Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Wed, 02 Apr 2003 @ 17:32:20 GMT





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




Subj:   Re: Numeric overflow when inserting
 
From:   Sam Sterling



You might want to run some queries with the computations and get the answers back - one (or more) will overflow, but it'll bring back the ******** showing what happened.

I'd be suspicious of the smallint first. Then, depending on the computation, the decimal(10,2).

Sam Sterling
Baseline Consulting





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008