Re: midnight killin
Posted in 2006
Topics: SQL Development & Query Writing
Bill64bits asked:
>has anyone got a select statement that will give the session id's for
a
given "user"?
select sid from sysmaster:syssessions where username = "<insert namehere>" ;
would seem to do what you want.
Thanks. That was easier than I expected.
I guess if I had just rtfm a little more ...
-----Original Message-----
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
On Behalf Of Curtis Crowson
Sent: Thursday, March 16, 2006 1:21 PM
To: informix-list@iiug.org
Subject: Re: midnight killin
Bill64bits asked:
>has anyone got a select statement that will give the session id's for
a
given "user"?
select sid from sysmaster:syssessions where username = "<insert namehere>" ;
would seem to do what you want.
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
__________ NOD32 1.1441 (20060313) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com