ERROR [21S01] The positional assignment list has too many values

Database
Visitor

ERROR [21S01] The positional assignment list has too many values

Hi, 

I keep receiving 'ERROR [21S01] The positional assignment list has too many values'. I have checked the indexes (?,?) and they have the correct variables in match with the columns however this message keeps appearing. 

 

Anyone aware of this error code? 

 

Thanks

2 REPLIES
Enthusiast

Re: ERROR [21S01] The positional assignment list has too many values

It should be a mismatch in number of columns in your insert statement. You might be trying to insert more columns than your target can actually have.

 

For reference on this error:

http://community.teradata.com/t5/Database/RDBMS-error-3813-The-positional-assignment-list-has-too-ma...

http://community.teradata.com/t5/UDA/The-positional-assignment-list-has-too-many-values/td-p/7284

SR
Teradata Employee

Re: ERROR [21S01] The positional assignment list has too many values

can you post the DDL of the table you're inserting into, as well as the insert statement?