The Strategy ODBC driver for DB2 Wire Protocol driver does the package creation and binding automatically. Refer to the following Knowledge Base technical note for more information on this:
If the values in a data source change after the packages have been created, the user can re-create the packages manually with the new values. This document outlines the procedure for manually creating packages and binding them for this driver.
Strategy ODBC Driver for DB2 Wire Protocol on Windows
This driver allows package creation and binding from the 'Modify Bindings' tab as shown on the screenshot below:
Users can click on the 'Help' button and check out information in Step #4 under "Configuring Data Sources" for more details about this 'Modify Bindings' tab. The User ID must have appropriate privileges on the database for the driver to create and bind packages. These privileges are BINDADD for binding packages and GRANT for executing the packages. Make sure the 'Grant Execute to Public' box is checked so that any other user can access these created packages.
Upon clicking the 'Modify Bindings' button, the user will be prompted for a user name and password. Thereafter, the packages should be successfully created and bound.
Strategy ODBC Driver for DB2 Wire Protocol on Unix (Linux, AIX, Solaris, HP-UX)
Manual package creation and binding is done through a utility called bind## that is shipped with the product.
Follow the steps below to perform manual package creation and binding on Solaris, Linux and HP-UX operating systems:
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
