You
can use the Run Settings window to specify which collection
ID to use when you run a SQL or SQLJ stored procedure with multiple
package
variations.
About this task
To specify which package variation
to use when running a stored
procedure on a DB2® for z/OS® server:
- In the Data Source Explorer, right-click the stored procedure
in a DB2 for z/OS connection
and click Run Settings. The
Run Settings
window opens.
- On the Options page, browse
to the collection ID that contains
the package variation that you want to use to run this stored procedure.
- Click OK.
Results
The next time you run this stored procedure, the package variation
that is defined in the collection ID that you specified is used.