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