Archives of the TeradataForum
Message Posted: Wed, 09 Sep 2015 @ 22:57:18 GMT
Have a look in the DML manual. You will see that the Insert query supports a "logging errors" clause. I have not tried it personally, but it may a good place for you to start.
The syntax looks something like this:
Insert into blah Select blah, blah, blah From blah LOGGING ERRORS ;
There are a few options and you need to create an error table. The manual explains it all.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|