Archives of the TeradataForum

Message Posted: Fri, 08 Nov 2013 @ 12:28:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

How about seeing them in error table ?

How about increasing the errlimit maybe around 100000 records and at one go read the entire errored out file and correct them.

Also put checkpoint if necessary.

See that you may need to correct the second error table too.

Since I am comfortable in unix, so I used to correct the bad characters using vi and sed.

There was a time when the file was too huge, I could not do it reading AbInitio. So it was hard to find, then. If now, I could have broken files Into many partitions and load them.

Cheers,

Raja

	<Prev	Next>		<<First	<Prev	Next>	Last>>