Re: Geeting the SID of a connection

From: Carlos Benjamin <benj@firstlinux.net> > >--- "Obnoxio The Clown" <obnoxio@hotmail.com> > > wrote: > >From: Nicolas HERVE <nherve@nagora.com> > >> > >>I'm doing a connections pool, and I need the SID of each connection to > >>ba associated with the connection. So I could say at any time that > >>connection with SID xxx is up or down, or doinf this or that. I can't > >>get this with the system tables as the only index for the connections is > >>the SID ... > > > >So I guess > > > >SELECT DBINFO('sessionid') > >FROM systables > >WHERE tabid = 1 > > > >is out of the question? > > > >This manual reading lark could become addictive. You have *no* *idea* how > >much fun stuff is in there... > >I always read manually. I don't have an automated reader at my >disposal..... > >Or did you mean to indicate that you have a bird that reads manuals for >you? Yes. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com