Debugger Support (Revision #44)

Aqua Data Studio 7 expands debugging support to include integrated debuggers for DB2 for LUW and Microsoft SQL Server. Each debugger has been designed to aid in the testing and debugging of your SQL functions and procedures.

We’ve also improved the functionality of all debuggers. You can now debug one statement at a time using Step Into and Step Return for a line-by-line view of what’s happening while executing stored procedures. This allows you to step into a second procedure while continuing to debug the first.

Step Into, Step Return	DB2 Debugger	MS SQL Server Debugger

Feature Overview

• Added debugger support for MS SQL Server, DB2 UDB stored procedures and user-defined functions, in addition to existing support for Oracle SQL and Sybase SQL.
• Step Into – Debug one statement at a time using this new functionality.
• Step Return – Set breakpoints and toggle them on and off with ease. Then run a stored procedure to completion or resume execution to the next breakpoint.
• Support for Charts – The charting tool is integrated with all debuggers, allowing you to view pivot grid results and sort the table results.
• Shortcuts – Debug related keyboard shortcuts for Step Into (F7) and Step Return (Shift + F8).

Documentation -> Debuggers

Documentation -> MS SQL Debugger

Documentation -> DB2 Debugger