Unique identifier of the current transaction

TypeBIGINT

Syntax

  |CURRENT_TRANSACTION

The transaction identifier is derived from a counter on the database header page, which is incremented for each new transaction. When a database is restored, this counter is reset to zero.

Examples

  |select current_transaction from rdb$database
  | 
  |New.Txn_ID = current_transaction;