A keyword followed by a host language variable (distributed-tid)
in application programs. When you want the transaction you are
starting to join a distributed transaction, use this clause to
specify the distributed TID of the distributed transaction that
you want your transaction to join.
The distributed-tid is a host language variable. You use the
distributed-tid variable to hold the value of the distributed TID
that DECdtm services generates and returns to the application.
DECdtm services uses the distributed TID to distinguish the
databases involved in a particular distributed transaction.
Note that if you want to start a distributed transaction, you
should use only the DISTRIBUTED_TRANSACTION clause. However, if
you want your application to start a transaction that will join a
distributed transaction, then you must use both the DISTRIBUTED_
TRANSACTION clause and the DISTRIBUTED_TID distributed-tid
clause.
Your application must explicitly call the SYS$START_TRANS system
service and you must specify the DISTRIBUTED_TID distributed-
tid clause if you want the transaction you are starting to join
a distributed transaction. The distributed-tid variable is an
octaword (16 bytes) that you should declare and initialize to
zero at the beginning of your application.
Do not use the DISTRIBUTED_TID clause in interactive RDO. It is
valid only in RDBPRE and Callable RDO.
For complete information on distributed transactions, see the
Oracle Rdb Guide to Distributed Transactions.