How to determine session ID (ESQL/C)

Posted in 1996

Paul Kapp — Mon, 02 Dec 1996 07:47:00 -0400 — source: Informix-list mailing list archive (1991-1998)

How does one determine a connected database session ID from within the client application program? I would like to log users sessions by session ID to use in some monitoring tools using the sysmaster database. Since some users connect multiple times, I'm not guaranteed uniqueness there, and we have most connections via v5.0 clients, so the ProcessID is frequently (-1). I figured out one way, by an elaborate query against sysmaster:syssqexplain, but I figure there has got to be a better way. Thanks in advance Paul.