Create, test, and deploy a DB2 SQL stored procedure

Lessons in this tutorial

• Setting up your environment
  
  In this first exercise, you will access the IBM SQL and Routine Development perspective and view data preferences. The IBM SQL and Routine Development perspective in the workbench is where you do all of your work in this tutorial.
• Creating a connection to the GSDB database
  
  The workbench provides wizards that make it easy for you to connect to both DB2 and non-DB2 databases and to display the status of your connections. The New Connection wizard creates a connection to a database in the Data Source Explorer view. For the purposes of this tutorial you connect to the GSDB sample database.
• Creating a project for stored procedure development
  
  In order to create database objects, you must create a data development project in which to store the objects. Each data development project is associated with a single database connection. In this tutorial, you use the connection information from the GSDB4tutorial connection that you created in the last exercise to create the project.
• Creating an SQL stored procedure
  
  In this exercise, you use a wizard to create a DB2 SQL stored procedure. This simple stored procedure returns employee information from the EMP_EMPLOYEE_DIM table when the employee's organization ID matches a value that the user enters.
• Deploying the stored procedure for development
  
  In this exercise, you use a wizard to deploy the stored procedure for development so that you can continue working with it in the Data Project Explorer view.
• Debugging the stored procedure
  
  The workbench includes an integrated stored procedure debugger. By stepping through your code while you are running in debug mode and viewing the results, you can discover problems with your stored procedure and make the necessary changes.
• Running the stored procedure
  
  You can run the stored procedure for testing purposes. When you run the stored procedure, you can determine whether the run is successful and whether the result set exists. You can also test the logic of the routine and the accuracy of output arguments and result sets. When you run a stored procedure from the workbench, the workbench calls the stored procedure, and the results are displayed in the SQL Results view.
• Deploying the stored procedure for production by using a deployment group
  
  In this exercise, you use a wizard to create a deployment group and then deploy the stored procedure for production from the deployment group.