DB2Connection.EnlistDistributedTransaction Method

Enlists in the specified transaction as a distributed transaction.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax


[Visual Basic]
Public Sub EnlistDistributedTransaction( _
   ByVal transaction As ITransaction _
)
[C#]
public void EnlistDistributedTransaction(
   ITransaction transaction
);
[C++]
public: void EnlistDistributedTransaction(
   ITransaction* transaction
);
[JScript]
public function EnlistDistributedTransaction(
   transaction : ITransaction
);

Parameters

transaction: A reference to an existing transaction in which to enlist.

Remarks

You can enlist in an existing distributed transaction using the EnlistDistributedTransaction method if auto-enlistment is disabled. Enlisting in an existing distributed transaction ensures that, if the transaction is committed or rolled back, modifications made by the code at the data source are also committed or rolled back.

The Chaos isolation level can be used in Distributed Transactions the same way as in local transactions. That is, all changes are committed upon successful change operation irrespective of whether commit is issued on the transaction or not. The Chaos isolation level is valid only for Db2® for i servers.

CAUTION:

EnlistDistributedTransaction returns an exception if the DB2®Connection has already started a transaction using BeginTransaction . However, if the transaction is a local transaction started at the data source (for example, by explicity executing the BEGIN TRANSACTION statement using a DB2Command object), EnlistDistributedTransaction rolls back the local transaction and enlists in the existing distributed transaction as requested. You will not receive notice that the local transaction was rolled back, and are responsible for managing any local transactions not started using BeginTransaction.