IBM Database Add-Ins for Visual Studio  

Specifying Package Variations when Running SQL Procedures on DB2 for z/OS Servers

When you run a DB2® SQL procedure with multiple package variations, you can indicate which package variation to use by the collection ID that you specify in the Run Options window.

You can also specify package variations for versions of z/OS native SQL procedures in the same way that you specify package variations for SQL procedures.

To specify a package variation when running an SQL procedure on a DB2 for z/OS server:

  1. In the Server Explorer under your data connection, right-click the SQL procedure that you want to run, and then click Run.

    The Run Options window opens.

  2. In the Collection ID list, select the collection ID for the package variation that you want to run.
  3. Proceed with the remaining steps in running a procedure.

See Also

Managing Package Variations for SQL Procedures | Defining Package Variations for SQL Procedures | Run Options


.NET Development Forum   DB2 FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.