Re: I am in a transaction ?? (I4GL)

Posted in 2009

pontes.vagner@gmail.com — Wed, 27 May 2009 12:40:21 -0700 (PDT) — source: Usenet: comp.databases.informix

To know if your current session has transaction opened use dbinfo to get your session id and : select address into waddress from sysrstcb where sid=? select bitval(flags,2) 0-No trans opened/1-The transaction is opened from systxptab where owner= waddress Best regards