Tuesday, May 05, 2009

Debugging SQL procedures with the System i graphical debugger and DB2 developers workbench

IBM® DB2® for i5/OS® first simplified the debugging of SQL procedures, functions and triggers in the
IBM OS/400® Version 5 Release 2 operating system with the introduction of the SQL *SOURCE Debug
View. (See the article entitled “Graphical Debugger Makes Procedural SQL Debug Even Easier,”
published in the March 2003 issue of iSeries NEWS:
_Easier.html.) In conjunction with the IBM Toolbox for Java™ System i System Debugger, this debug
view greatly simplified the debugging of SQL procedural objects.
With the DB2 for i5/OS V5R4 enhancements, developers now have another option when they need to
graphically debug SQL procedures. These new debug capabilities are provided by the IBM DB2
Developer’s Workbench (formerly known as IBM DB2 Development Center). The Developer Workbench
is a visual tool that supports the entire DB2 family across all IBM platforms for the rapid development of
DB2 business objects. The DB2 Developer Workbench only supports the debugging of SQL and Java
stored procedures.


No comments:

Post a Comment