开发者

Debug DB2 stored proc

开发者 https://www.devze.com 2023-03-21 10:31 出处:网络
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 t

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 thi开发者_StackOverflows ?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消