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

Posted in 1996

Koen Van der Elst — Wed, 10 Jul 1996 19:00:28 GMT — source: Informix-list mailing list archive (1991-1998)

>> 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. . . . >You can get sessions by selecting syssessions table in a stored >procedure called by a trigger. What if you start different sessions on a PC (client/server). I can't trace back a particular session-id in that case. Can someone help me out ? Koen