Archives of the TeradataForum
Message Posted: Fri, 16 Jan 2004 @ 15:37:35 GMT
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
|