Archives of the TeradataForum
Message Posted: Fri, 08 Nov 2013 @ 12:28:35 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|