Application development with .NET - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 264

The Procedure Designer window is shown in Figure 6-10.
Figure 6-10 Procedure Designer window
Note: At time of DB2 9 release, CLR Procedure can only be created using the
wizard. Only SQL Procedure Designer is available.
The menu provided in Procedure Designer window includes the following:
Procedure View: Allows defining procedure parameters and procedure body.
Privileges View: Allows adding roles and privileges to the users or groups.
Show Script View: Shows the create procedure statement.
Debugging SQL procedures
Debugging support for SQL procedure has been extended to zSeries servers.
Procedure can be debugged using the following steps:
1. Create SQL procedure with Debug mode option set to ALLOW.
2. Add breakpoints in SQL body.