Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Tue, 09 Aug 2005 @ 17:45:06 GMT





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




Subj:   Re: Cast to Decimal - Error 2679
 
From:   Anomy Anom



<-- Anonymously Posted: Tuesday, August 09, 2005 13:43 -->

Just to follow up folks with the final word from the GSC, the maximum number of numeric characters that can be SENT to a decimal or float data type is 20. Teradata will round as needed on 20 or less characters, but 21 or more characters will cause error 2679. This is obviously a different issue than how large or small a value can be stored, which is well known. I have asked them to update the Teradata documentation with this limit.





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