CODEWITHSUNDEEP
db2toad
Cannon
Cannon

Reputation: 2793

Debug DB2 stored proc

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 ?

Upvotes: 3

Views: 1990

Answers (1)

Ian Bjorhovde
Ian Bjorhovde

Reputation: 11052

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.

Upvotes: 1

Related Questions