Debugging in IBM Data Studio by Phil Nelson

Once you have written a stored procedure or two you'll very soon want to debug it.   There's nothing like stepping through the code line-by-line to try to find out what is going wrong.  Thankfully IBM Data Studio provides a very good debugger for SQL stored procedures.

This article by Phil Nelson will step you through the use of the debugger in IBM Data Studio.

http://www.idug.org/p/do/sd/sid=6445&type=0

 

Recent Stories
Some of my favorite tunings tips and tricks for DB2 by Joe Geller

SQL Tuning for Developers – Part 1

The Key To Mastering Db2 Locking On Row-Store Tables