Try ... Catch

[appletastic]

Hi all,

I had a question regarding error handling in DB2 SQL I seem to be having some issues.

So far I have a procedure, but I need to add a try and catch block in there and withing the catch block I need to store the Error Message as a value into a table. I am having issues with the syntax

So far it Looks like:

Create Procedure dummy
Begin
Try:
{CODE}
Catch:
 Need to grab error message and put it into a table 
insert into table_name values(ERROR_MESSAGE());
 
end; 

Any help would be greatly appreciated

Thanks,
Apple