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. [...]