April 2015 “Fun with SQL” Challenge 2
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
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.
In this entry we will look at the use of IBM Data Studio in the development life cycle SQL Procedure Language (SQL PL) stored procedures on both DB2 for z/OS as well as DB2 LUW. A “cheat sheet” for some of the more common SQL PL commands is found on the last page of this article.
IBM Data Studio is a no-charge download that provides lots of functionality for working with DB2 databases on all platforms. This post will help direct you to some resources for finding out more about IBM Data Studio.