This video is a presentation given at the IDUG DB2 North America Tech Conference in May 2015. It begins with Adrian Burke discussing the challenges associated with tuning dynamic SQL. Then Saghi Amirsoleymani comes in to discuss the features in the no-charge version of IBM Data Studio.
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.
IBM Data Studio is a no-charge product provided by IBM to allow users, developers and administrators to interact with databases from a client machine.