Hi all,


I'm invoking Informix Stored Procedure from Java(using JDBC); I want to kill/stop the Stored Procedure and rollback the data; My Environment is: Informix 9.4 , java 1.4.1(JDBC) ;

How to kill the Stored Procedure and roll back the data;
(how to get the session id ,pid and which command/sql command i've to use to kill the informix session programmaticly -->using Stored procedure/sql/esql)


Thanks
om

Hi Om,

You can run the below commands from unix command prompt, i am not too sure how you would do it in stored procedure.

To view all the active sessions

onstat -g ses

To kill a particular session

onmode -z <sessionid>


Regards,

lloyd

Hi lloyd,

Any way thanks , but i'm looking for programmtically;
i thing with dbinfo('sessionid") , i can do that;
then execute onmode -z sessionid;



thanks
om