cancelling a stored procedure from Clarion

[dadkins]

thread192-621975: I'm calling stored procedures from Clarion. Is it possible to issue a command to cancel the stored procedure once it's been called? I've done some research, but have not found a way to do this.

Thanks

 

[ShankarJ]

Hi!

I am not sure why you want to stop a stored procedure but I assume it is because it is running too long. So, have you researched ways to optimize the code? Anyway, answering your question ::

- Assuming that you are looping in some way in your stored procedure, you can check a global temp table for a value and if it finds it, it gracefully rolls back the changes and exits.

- The brute force way is to find the Process ID and kill the process. Read more at

http://www.kodyaz.com/articles/kill-all-processes-of-a-database.aspx.

Regards