Preparing to debug a DB2 SQL stored procedure

After you build an SQL stored procedure in debug mode, you can start the debugger and step through the source code. This topic describes how to prepare an SQL stored procedure for debugging.

Debug support is only available for SQL stored procedures for DB2 Universal Database for Linux, UNIX, and Windows.

To prepare a DB2 SQL stored procedure for debugging:

1. Switch to the Data perspective.

2. Build the SQL stored procedure for debugging.

3. In the Data Definition view, right-click the SQL stored procedure that you want to debug and click Debug.

4. In the Launch Configuration window, provide the necessary configuration settings.

5. Click Debug.

The stored procedure opens in the Debug perspective, where you can debug the code.

 

Parent topic

DB2 stored procedures

 

Related concepts

Overview of DB2 stored procedures tasks
Tips for developing DB2 stored procedures

 

Related tasks

Creating DB2 stored procedures
Building DB2 routines

Related reference
Stored procedure task restrictions
Stored procedure and user-defined function support by DB2 Universal Database server type