You already answer most of your question.
1. execute immediate and get spid.
2. I assume there is a disconnect statement you can used in sybase to disconnect the
one that is using the spid you just retrieve.
"Kaluza, Isabel SLGA" <[EMAIL PROTECTED]> wrote:
>I want to do the following on a page
>
>1. select spid from sysprocesses, syslogins
>where sysprocesses.suid = syslogins.suid
>and name = 'trace'
>
>2. get the spid returned above
>
>3. Execute kill spid
>
>Is this possible? How do I do it in java of my page? I am using the
>database sybase?
>
>Thanx for your help
>
>-----Original Message-----
>Sent: Sun, Jan 30, 2000 09:57 PM
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
