You can use the IBM Database Add-Ins for Visual Studio to create variations of packages for SQL procedures that target DB2® for z/OS®. You can specify different bind options for each package. When you run a procedure, you can use the Run Options window to pick a collection ID from all of the collection IDs that are associated with a package so that you can run the appropriate package variation.
You can also define package variations for versions of native SQL procedures in the same way that you define package variations for SQL procedures.
To define a package variation for an SQL procedure:
- In the Server Explorer under your DB2 for z/OS data connection,
right-click the procedure, and then select Show
Packages on the shortcut menu.
The Packages window opens.
- Click + to add a new package variation to the Packages list.
- With the new package variation selected in the
Packages list, click
in the value cell of
the target BindOptions property to open the
Bind Options
window, and specify the bind options for the package
variation. - Select a target collection ID for the package variation.
- In the target Location list, select an existing data connection for the package variation, or select New to define a new target connection in the Add Connection window.
- To define another package variation, return to step 2.
- Click OK to close the Packages window.
See Also
Managing Package Variations for SQL Procedures | Specifying Package Variations when Running SQL Procedures on DB2 for z/OS Servers
.NET Development Forum DB2 FAQs
© Copyright IBM Corporation 2002, 2019. All Rights Reserved.