RDB$TRANSACTIONS

From InterBase
Jump to: navigation, search

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