Walter wrote:

Is it possible to have a SELECT which says me if the current transaction

  • Is READ COMMITED or SNAPSHOT
  • Is READ ONLY or READ WRITE
  • Is WAIT or NO WAIT

??

Thomas Steinmaurer answers:

SELECT *
FROM
  MON$TRANSACTIONS
WHERE
  MON$TRANSACTION_ID = CURRENT_TRANSACTION

Like this post? Share on: TwitterFacebookEmail


Related Articles


Author

Firebird Community

Published

Category

Gems from Firebird Support list

Tags