Toad World® Forums

TOAD - DB2 - Debugging Stored Procedures


#1

How do you debug Stored Procedures?
Because if there is a way, it is not very user friendly at all.
6.5.0.125 (64 bit) Registered.


#2

Toad DB2 supports the debugging of SQL procedures.
To invoke the debugger ensure that your SQL procedure has its “Debug Mode” property set to “ALLOW”.
Then right click on the procedure and select “Debug”.

If your SQL Procedure does not have its “Debug Mode” property set to “ALLOW”, right-click on the procedure and select “Compiler SQL Procedure with Debug” before attempting to debug the proc.


#3

Is there a tutorial on this?


#4

There is a video that shows you how to debug a SQL procedure at:


#5

thanks for the video.