Hello. I'm working with some .NET code at the moment that performs the following operations:
I'm trying to wrap the whole operation in a single transaction (using the .NET framework's TransactionScope object), but the updates to the Teradata data always get committed, even if I throw an exception before calling TransactionScope.Complete(). I believe my efforts here are being thwarted by Teradata's "auto-commit" feature.
I get the desired results with multiple Transaction objects, like so:
No; Teradata Database does not support distributed transactions.
I hate to disagree, but we have distributed transactions between Teradata and MSSQL working just fine.