If you have DB2® SQL procedures that you need to run with different bind options at different times, you can easily accomplish this with package variations.
With the IBM® Database Add-Ins for Visual Studio, you can define variations of SQL procedure packages on a DB2 for z/OS server, Version 9.1 or later. You can see all of the package variations that are associated with an SQL procedure and the properties for each variation, including the bind options. In the Packages window, you can define new package variations, change the properties for existing package variations, and delete package variations.
At runtime, you decide which package to run by selecting the collection ID that identifies the appropriate package variation.
If you create multiple versions of SQL procedures in DB2 for z/OS Version 9.1 or later, you can define package variations for one or more procedure versions. At runtime, you can then select the specific package variation of an SQL procedure version that you want to run.
Managing Package Variations for SQL Procedures | Defining Package Variations for SQL Procedures | Specifying Package Variations when Running SQL Procedures on DB2 for z/OS servers | Packages | Run Options