Use the new developerWorks tutorial created by Eric Johnson to learn how to debug SQL stored procedures using Visual Studio 2005.
Title: IBM Database Add-Ins for Visual Studio 2005, Part 2: Deploy, debug, and correct your SQL stored procedures
Follow steps to deploy, debug, and correct SQL stored procedures using IBM® Database Add-ins for Visual Studio 2005.
In this tutorial
* Create a stored procedure that updates the salaries in the EMPLOYEE table of the sample database.* Use the major features of the SQL stored procedure debugger.
* Use the SQL stored procedure debugging features to test SQL stored procedures, and to find and fix problems in them.* Learn about the features of debugging SQL stored procedures when run from Visual Studio 2005.
This tutorial is written for DB2® SQL PL programmers. Familiarity with DB2 SQL PL is assumed.
General familiarity with the IBM Database Add-ins for Visual Studio 2005 is also assumed. To become more familiar with the general features of the IBM Database Add-ins for Visual Studio, see Overview of IBM Database Add-ins for Visual Studio 2005 and the Develop proof-of-concepts .NET applications tutorial series.
System requirements To complete this tutorial, you need a DB2 9 database server. You also need to have the DB2 server or client installed on a workstation with Microsoft Visual Studio 2005 and Version 9 fix pack 2 (FP2) or later of the IBM Database Add-ins for Visual Studio 2005. Finally, you need the sample database that comes with the DB2 database server.