Archives of the TeradataForum

Message Posted: Wed, 11 Jan 2006 @ 22:58:32 GMT

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

This error 3813 "The positional assignment list has too many values", and the similar error 3812 "The positional assignment list has too few values" are easy to cause when using so many columns (I've done it before). Carefully count the number of columns you have defined in the table you are inserting to, as well as the number of ? parameter markers in the INSERT statement. They need to match.

This error description is found in the Teradata Messages manual.

Tim

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