Deploying a Java stored procedure
A stored procedure must be deployed to the database where it is stored in the catalog, ready for execution.
To deploy a Java stored procedure to a database:
| In the Data Project Explorer, expand RAD75DataDevelopment Æ Stored Procedures, right-click ADDCREDIT, and select Deploy. |
|
| The Deploy Routines wizard opens. Enter ITSO as the Schema name and click Finish (Figure | 1-21). |
Figure 11-21 Deploy Routines
|
| You can see a succeeded build status in the SQL Results view. |
|
| In the Data Source Explorer, expand ITSOBANK Æ Schemas Æ ITSO Æ right-click Stored Procedures, and select Refresh. You can see that ADDCREDIT has been added to the Stored Procedures folder. |
|
ibm.com/redbooks |