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.
Procedure
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.