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:
[I]Need to grab error message and put it into a table[/I] 
insert into table_name values(ERROR_MESSAGE());

end;

Any help would be greatly appreciated

Thanks,
Apple