I got the same error message ("Field too large in vartext data record") and I did to things (and unfortunatelly don't know which helped):
-allocate more character in create table statement, than the define statement. I saw that fastload allocates 22 characters if you set the variable to varchar(20) for example. Meaning, probably it needs more space in the table than defined
-and changed the file format from txt to the simpliest csv I found.
Hi, I am getting the same error. Please help.
1736367089734 2073445845 9/2/2011 19:30:35 4073591282073445845 00000000000000000000
the above is my data. i have created a table in teradata.. i am using fastload to load this data, but it is throwing this error:
Field too large in vartext data record: 1, field: