How to skip data errors during fastload?

Tools
Enthusiast

How to skip data errors during fastload?

Hi,

Is it possible to skip data errors during fastload and continue with loading other records from file?
I have information in tab delimitted text files and in case some field is too long fastload stops to load all the data and reports the error.

In Oracle sqlloader records would go to bad file and I would be able later to decide wether I would like to deal with it or leave it as it is. Is something similar with fastload possible?

regards,
Roberts
3 REPLIES
Enthusiast

Re: How to skip data errors during fastload?

Use the NOSTOP option on the SET RECORD command.
Enthusiast

Re: How to skip data errors during fastload?

Thank you! nostop helped.

Regards,
Roberts
Teradata Employee

Re: How to skip data errors during fastload?

BTW, the NOSTOP option only works for VARTEXT record formats. It does NOT work for the binary formats.
-- SteveF