< Previous | Next >

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.
When you deploy a routine, the workbench performs the following actions:
  • For Java routines, the source code is compiled on your client workstation.
  • For SQL routines, the source code is compiled on the server.
  • The source code is copied to the DB2 server.
  • The routine is registered in the catalog table.

To deploy the stored procedure for development:

  1. In the Data Project Explorer view, right-click the SPEmployee stored procedure, and then select Deploy. The Deploy Routines wizard opens.
  2. On the Deploy Options page of the wizard, select GOSALESDW as the target schema, and then click Next.
  3. On the Routine Options page, select the Enable debugging check box, and then click Finish.

Messages that show the status of the deployment process are displayed in the SQL Results view. On completion, the stored procedure, SPEmployee, is added to the Stored Procedures folder under the GOSALESDW schema in the Data Source Explorer view.

In the Data Project Explorer view, the icon next to the SPEmployee stored procedure has a wrench on it to indicate that the stored procedure is deployed.

Because you selected the Enable debugging option in the wizard, the stored procedure is enabled for debugging.

< Previous | Next >

Feedback