Oninit cdi / Archive
Talk to an expert →

RE: getting current transaction id

Posted in 1997

"Wanda Beck" — — source: Informix-list mailing list archive (1991-1998)

Thanks for responding. Does that mean all my transactions during a session have the same id? How do I differentiate between two singletons or between a singleton and all the operations within a BEGIN WORK/COMMIT WORK transaction? Thanks! wa -- Wanda Beck richard_thomas@yes.optus.com.au ("Richard Thomas") on 08/11/97 01:14:45 PM To: wbeck@sybase.com (""Wanda Beck"") @ smtp cc: (bcc: Wanda Beck/SYBASE) Subject: RE: getting current transaction id If you are using 7.2+, DBINFO('sessionid') is just what you want. RET +-------------------------------------------------------------------------- --+ | Richard Thomas (DBA) richard_thomas@yes.optus.com.au +61 2 9342 7188 | +-------------------------------------------------------------------------- --+ ___________________________________________________________________________ ____ From: "Wanda Beck" on Fri, 8 Aug 1997 15:10 Subject: getting current transaction id To: informix-list@rmy.emory.edu From within a trigger, I'd like to get the transaction id of the triggering statement. Does anyone have an efficient way of doing that? Thanks! -- Wanda Beck Voice: (303) 413-4236 Fax: (303) 413-4025 email: wbeck@sybase.com ------------------ RFC822 Header Follows ------------------ >Received: by yes.optus.com.au with SMTP;6 Aug 1997 16:53:19 +1000 >Received: from news.optus.com.au ([203.13.126.11]) > by prairiedog.optus.com.au (Netscape Messaging Server 3.1b) > with ESMTP id AAA2AA7; Wed, 6 Aug 1997 05:15:42 +1000 >Received: from happy.optus.com.au (firewall-user@happy.optus.com.au >[203.13.126.9]) by news.optus.com.au (8.8.3/8.8.3) with ESMTP id FAA11458; >Wed, 6 Aug 1997 05:15:41 +1000 >Received: by happy.optus.com.au; id FAA25140; Wed, 6 Aug 1997 05:15:45 >+1000 (EST) >Received: from rmy.rmy.emory.edu(170.140.97.4) by happy.optus.com.au via >smap (3.2) > id xma025128; Wed, 6 Aug 97 05:15:33 +1000 >Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id >MAA12090 for informix-list-out; Tue, 5 Aug 1997 12:35:01 -0400 (EDT) >X-Lotus-Fromdomain: SYBASENOTES >From: "Wanda Beck"<wbeck@sybase.com> >To: informix-list@rmy.emory.edu >Message-Id: <872564EA.005AC4C2.00@concordnotes1.powersoft.com> >Date: Tue, 5 Aug 1997 10:31:26 -0600 >Subject: getting current transaction id >Mime-Version: 1.0 >Content-Type: text/plain; charset=US-ASCII >Sender: informix-list-owner@rmy.emory.edu >Reply-To: "Wanda Beck"<wbeck@sybase.com> >X-Informix-List-Id: <list.15779> > > > > >

Related threads