Level: Introductory Eric Johnson (ejohnson@us.ibm.com), Advisory Software Engineer, IBM
23 Aug 2007 Combine debugging C# applications with SQL stored procedures, in Part
3 of this series. Parts 1 and 2 of this series were about debugging SQL stored
procedures on their own. In this tutorial
- Create two Windows® applications that call DB2 SQL stored procedures: one hand-coded
command-line application, and one GUI application developed largely through drag-and-drop features of Microsoft
Visual Studio.
- Enable DB2 SQL stored procedure debugging in the Visual Studio projects for these applications,
and use the DB2 SQL stored procedure debugger along with the C# debugger in a single debugging session.
Objectives - Enable DB2 SQL stored procedure debugging in C# projects.
- Use DB2 SQL stored procedure debugging along with C# application debugging.
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,read the "Overview
of IBM Database Add-ins for Visual Studio 2005" (developerWorks, December 2005) and the Develop proof-of-concepts .NET applications tutorial series.
You should also be familiar with the DB2 SQL stored procedure debugging features
of the IBM Database Add-ins for Visual Studio. Reading the first two parts of this series is recommended before completing this tutorial.
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.
| 
