Re: Getting the current transaction id

Posted in 2004

Claus Samuelsen — Sat, 02 Oct 2004 11:13:50 +0200 — source: Usenet: comp.databases.informix

Clive Haworth wrote: > Hi. > > I need to get hold of the current transaction id. In oracle you can use > something like: > > select dbms_transaction.local_transaction_id from dual> > This returns an identifier uniquely representing the current transaction, or > null if not in a transaction. > > Does anyone know how to do this in IDS 9.20 or above? > > In IDS 9.40 a new function was added to milib: mi_get_transaction_id() returning id of current transaction.