Firebird Documentation Index → Firebird 2.0 Language Ref. Update → Context variables → CURRENT_TRANSACTION |
Find a more recent version at Firebird 5.0 Language Reference: CURRENT_TRANSACTION
Available in: DSQL, PSQL
Added in: 1.5
Description: CURRENT_TRANSACTION
contains the unique identifier of the current
transaction.
Type: INTEGER
Examples:
select current_transaction from rdb$databaseNew.Txn_ID = current_transaction;
The value of CURRENT_TRANSACTION
is stored on the database header
page and reset upon restore. Unlike CURRENT_CONNECTION
, it is incremented
with every new transaction, whether the client reads the value or not.
Firebird Documentation Index → Firebird 2.0 Language Ref. Update → Context variables → CURRENT_TRANSACTION |