Deploying SQL Procedures to Databases (DB2 for z/OS)
You can use the IBM Database Add-Ins for Visual Studio to
deploy native SQL procedures to a DB2® for z/OS® database. The source
and target databases for the deployment must both be on a DB2
for z/OS Version 9.1 or later server.
You can deploy a native SQL procedure in one of two ways:
You can deploy binaries that were previously built on the
server. The binaries for the SQL procedure are copied from
the source to the target server. If no binaries are available,
a full build is done automatically.
You can deploy by doing a full build.
You can also deploy versions of native SQL procedures to a
database in the same way that you deploy SQL procedures.
To deploy an SQL procedure to a
database:
In the Server Explorer under your DB2 for z/OS data connection,
right-click the native SQL procedure that you want to deploy, and
then select Deploy on the shortcut menu.
In the Location list, select an existing
data connection for the target, or select New
to define a new target connection in the
Add Connection
window.
Select the collection ID for deploying the procedure.
Optional: Specify the database schema for the deployed
procedure.
Click OK to close the Deploy Routines
window.
The deploy process begins. You can view the progress and
messages in the IBM Output Message Pane. After the procedure
is deployed, you can refresh the Procedures
node under the target data connection in the Server Explorer
view to verify that the procedure was added to the server.