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:
- In the Data Project Explorer view, right-click the SPEmployee
stored procedure, and then select Deploy. The Deploy Routines wizard opens.
- On the Deploy Options page of the wizard, select GOSALESDW as
the target schema, and then click Next.
- 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.