Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 16 Oct 2003 @ 03:29:27 GMT





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




Subj:   Re: MLOAD ERROR 3813
 
From:   McCall, Glenn D



You don't provide much to go on.

The error means that you are supplying more values than columns in the table.

Examples:

1) Table two has two columns and you insert into two values (:field1, :field2, :field3);

OR

2) You do something like this insert into some_table (column_one) values (:field1, :field2);

In 1) the table has 2 columns but three values are supplied.

In 2) the insert is specifying one column, but 2 values are supplied.


Hope this helps.

Glenn Mc





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