Go Up to System Tables
RDB$TRANSACTIONS
keeps track of all multi-database transactions.
RDB$TRANSACTIONS
Column name
|
Datatype
|
Length
|
Description
|
RDB$TRANSACTION_ID
|
INTEGER
|
|
Identifies the multi-database transaction being described
- On ODS 15, it remains INTEGER
- On ODS 16, dialect 1 get a "double precision" type since it cannot support dtype_int64
- On ODS 16, dialect 3 (the majority of users) gets NUMERIC(18,0) which is the native dtype_int64 type.
|
RDB$TRANSACTION_STATE
|
SMALLINT
|
|
Indicates the state of the transaction
Valid values are:
- 0 - limbo
- 1 - committed
- 2 - rolled back
|
RDB$TIMESTAMP
|
DATE
|
|
Reserved for future use
|
RDB$TRANSACTION_DESCRIPTION
|
BLOB
|
|
Subtype TRANSACTION_DESCRIPTION ; describes a prepared multi-database transaction, available if the reconnect fails
|