|
|
Archives of the TeradataForum
Message Posted: Sat, 20 Nov 2010 @ 18:41:10 GMT
Subj: | | Re: Deadlock and BTEQ |
|
From: | | f.pluebell |
In Teradata (BT/ET) mode, a failing request automatically triggers ROLLBACK of the entire transaction before the error is reported to the
client.
BTEQ retry is at the request level, so it won't re-do the BT or intervening requests, just re-submit the failing request (as a the only request
in a new transaction) and continue. Yes, multistatement requests are implicit transactions, and often a better choice in BTEQ than using explicit
BT/ET.
Fred
| |