11.6 CURRENT_TRANSACTION

Available inDSQL, PSQL

TypeBIGINT

Syntax

  1. CURRENT_TRANSACTION

CURRENT_TRANSACTION contains the unique identifier of the current transaction.

Its value 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

  1. select current_transaction from rdb$database
  2.  
  3. New.Txn_ID = current_transaction;