DB2 Stored Procedure Builder is a graphical application that assists you with creating stored procedures that run on the entire DB2 database family ranging from DB2 Universal Database for a single workstation to DB2 Universal Database for OS/390. Using Stored Procedure Builder, you can perform the following tasks:
Using Stored Procedure Builder allows you to focus on creating stored procedure logic rather than the details of registering, building, and installing stored procedures on a DB2 server. Stored Procedure Builder is implemented with Java and all database connections are managed by using a Java Database Connectivity (JDBC) API. Using a JDBC driver, you can connect to, and build, stored procedures on any DB2 database by using a local alias.
With Stored Procedure Builder, you can create stored procedures in Java or the SQL procedure language. You can also run stored procedures that you created in another editor and that use a language other than Java or the SQL procedure language. You can run the stored procedures you created in another editor to test the logic.
For more information, see the DB2 Stored Procedure Builder online help.