Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → System Tables → RDB$TRANSACTIONS
Firebird Firebird Prev: RDB$SECURITY_CLASSESFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$TRIGGERS

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

Prev: RDB$SECURITY_CLASSESFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$TRIGGERS
Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → System Tables → RDB$TRANSACTIONS