ERROR: 3812, positional assignment list has too few values

Database
Enthusiast

ERROR: 3812, positional assignment list has too few values

hi

i am trying to load the teradata database from a flat file file with extension .dat using fastload. the server i am connecting to is a unix server.

i am specifying the dat file in my fld file, i am not using any stored procedure, no "?" parameter also.

i have 55 columns in my define statement+ 1 crlf and 55 columns in my insert statement.

but than also i am getting the error positional assignment list has too few values..

can someone tell me what can be the possible reasons for this and brief about positional assignments i am bit new to teradata.

thanking you
Akhshay Gandhi
1 REPLY
Enthusiast

Re: ERROR: 3812, positional assignment list has too few values

The 3218 error is a SQL syntax error. The target table (or column name list in the insert statement) has more columns than you specified values for.