Debug DB2 stored proc

Question

I am using IBM DB2 with Toad. I have a stored procedure that I need to debug.Any tutorial or videos on how to debug a stored procedure ? Echo statement won't work. One way would be to create a temp table, dump data in to it and open cursor at the end. But any alternative to this ?

Answer 1

I can't answer how to do this with Toad, but the (free) IBM Data Studio includes the ability to interactively debug stored procedures. You can set breakpoints, step through your procedure, see variable values during execution, etc.