You can use the workbench to create, test, and deploy DB2® or Derby stored procedures. You can also debug SQL stored procedures.
Stored procedures contain procedural constructs with SQL statements. Stored procedures are stored in databases and run on servers. An application can call a stored procedure by name and run the SQL statements that are included in the stored procedure. The application can be on the client, while the stored procedure executes its logic on the server. Stored procedures and user-defined functions are sometimes referred to collectively as routines.