By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

Different handlers in db2 stored procedure...

chandu031
Expert
P: 78
Hi ppl,
I am new to this community and am quite overwhelmed by the kind of discussions happening here. I thought I might get a solution here, so am posting my problem here :

I wanted to know if there are any other handlers we can write apart from those for sqlexception, sqlwarning and not found while writing stored procedures in DB2. For example if there is an interrupt while the procedure is running(like user interrupt or server shut down) is there any way to transfer the control to a handler routine? If yes, how do i declare this routine? Please note that I am working on DB2 client and connecting to a remote server and I am using a third party tool to connect to the database and write my procedures..

Thanks for your help in advance...
Mar 29 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.