FASTLOAD - Vartext Data - Error.

Tools & Utilities
Enthusiast

Re: FASTLOAD - Vartext Data - Error.

Thanks a lot Dieter..!!! That helps a lot.

Not applicable

Re: FASTLOAD - Vartext Data - Error.

Hi,

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.

Imre

Enthusiast

Re: FASTLOAD - Vartext Data - Error.

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:

Please help.