DB2 Development Center

IBM also provides DB2 Development Center (previously known as Stored Procedure Builder), a free product for developing SQL and Java stored procedures. The product is GUI-based and provides an easy-to-use interface for quickly developing and testing DB2 stored procedures written in Java or IBM's SQL Procedures Language.

DB2 Development Center provides a development environment for creating, installing, and testing stored procedures, that enables developers to focus on creating stored procedure logic instead of the mundane details of registering, building, and installing DB2 stored procedures. Additionally, with DB2 Development Center, you can develop stored procedures on one operating system and build them on other server operating systems.

Refer to Figures 15.5 for an example of using the DB2 Development Center to build a stored procedure.

Figure 15.5. Using DB2 Development Center to create a stored procedure.

You can launch the DB2 Development Center as a separate application, or from any of the following application development applications:

• Microsoft Visual Studio

• Microsoft Visual Basic

• IBM VisualAge for Java

The DB2 Development Center can be downloaded from the IBM Web site.