Available inDSQL, PSQL

Syntax

CURRENT_TRANSACTION

TypeINTEGER

DescriptionCURRENT_TRANSACTION contains the unique identifier of the current transaction.

Examples

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

The value of CURRENT_TRANSACTION is a 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.