Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 16 Jan 2004 @ 15:37:35 GMT


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


Subj:   Re: Fastload/Multiload Problem - Error 2683
 
From:   D Rewalt

Anomy Anon wrote:

  In the Multi load error table 2683 error is displayed.  



The 2683 error is a numeric overflow. You are trying to insert a number that is too large for the column to handle. For example: You're trying to insert the value 32768 into a column defined as a smallint. The largest positive value that a smallint column can handle is 32767.

The error tables created by the multiload should identify the columns that are in error. Redefine the columns so they can handle the larger values and you should be good to go.


I hope this helps.

- Dan



     
  <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