Specifying which package variation to use when running a stored procedure on a DB2 for z/OS server

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.

To specify which package variation to use when running a stored procedure on a DB2® for z/OS® server:

  1. In the Database Explorer, right-click the stored procedure in a DB2 for z/OS connection and click Run Settings. The Run Settings window opens.
  2. On the Options page, browse to the collection ID that contains the package variation that you want to use to run this stored procedure.
  3. Click OK.
The next time you run this stored procedure, the package variation that is defined in the collection ID that you specified is used.
Related information
Changing run settings for routines

Feedback