D.35 RDB$TRANSACTIONS

RDB$TRANSACTIONS stores the states of distributed transactions and other transactions that were prepared for two-phase commit with an explicit prepare message.

Column Name Data Type Description
RDB$TRANSACTION_ID INTEGER The unique identifier of the transaction being tracked
RDB$TRANSACTION_STATE SMALLINT Transaction state: 0 - in limbo 1 - committed 2 - rolled back
RDB$TIMESTAMP TIMESTAMP Not used
RDB$TRANSACTION_DESCRIPTION BLOB Describes the prepared transaction and could be a custom message supplied to isc_prepare_transaction2, even if it is not a distributed transaction. It may be used when a lost connection cannot be restored