Re: Getting the SessionID inside a Post/Pre insert trigger

Posted in 1996

Chao Y. Din — Mon, 08 Jul 1996 09:44:14 -0400 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote: > > Inside a stored procedure in OnLine version 7.2 at least, there is the > DBINFO('sessionid') call -- see Informix Guide to SQL: Syntax Version 7.2,> Volume 2, p1-693. > > Judging from the 7.1 manual, this is a new feature for 7.2, but it might be > worth trying anyway. > > Yours, > Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> > > >From: cxp1@chip.wda.disney.com (Charles Prabakar) > >Date: 3 Jul 1996 18:20:55 GMT > >X-Informix-List-Id: <news.25731> > > > >I wanted to know whether Informix has a function to get the SessionID on > >the fly inside a Post/Pre insert trigger. [...] You can get sessions by selecting syssessions table in a stored procedure called by a trigger. Chao Din