Archives of the TeradataForum
Message Posted: Thu, 28 Mar 2013 @ 16:18:44 GMT
| Subj: || || Re: Why BT-ET not working on large volume of data? |
| From: || || Anomy Anom |
<-- Anonymously Posted: Thursday, March 28, 2013 09:59 -->
Note that when an error occurs, Teradata mode rolls back changes since BT which then ends the transaction - before returning the error code to
the client. It is the client's responsibility to skip over any remaining SQL up to and including the corresponding ET;
In particular, if you are using BTEQ this means you need to check status after every SQL statement or use MAXERROR.