Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Jan 2006 @ 15:22:37 GMT


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


Subj:   Re: Positional Limit
 
From:   Victor Sokovin

  What is the limit of parameters I can specify in an Insert Into statement like this one?  


          > INSERT INTO X.Y
          >        VALUES (?,?,?,?,?,?,?,?,?,?, ...)
  I got the error code 3813 when trying to load a 80 columns file.  


I think the error message rather indicates that the number of values in the statement does not match the number of columns in the table. As you do not specify column names explicitly on the INSERT statement TD tries to do the default match, and it fails.

I think the safe way would be to either include all the column names in the appropriate order in the statement (would be my preferred method) or add the corresponding number of NULLs to the value list.

80 values sounds too low to be a general limit.


Regards,

Victor



     
  <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: 23 Jun 2019