Level: Introductory Eric Johnson (ejohnson@us.ibm.com), Advisory Software Engineer, IBM
09 Aug 2007 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.
Objectives - 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.
Prerequisites
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" (developerWorks, December 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.
Duration
1 hour
Formats html, pdf
Tutorial overview
IBM Database Add-ins for Visual Studio 2005 contains support for debugging SQL stored
procedures. SQL stored procedures can be debugged when run from Visual Studio 2005.
Additionally, SQL stored procedures may be debugged when run from your C# or Visual Basic
applications. This series shows how to use the SQL stored procedure debugging features
to test SQL stored procedures, and to find and fix problems in them.
| 
