Creating DB2 Packages Using List Files
You can bind the following list files on your database server to create DB2 packages:
DDODBC_LUW.lst (DB2 for Linux/UNIX/Windows)
DDODBC_400.lst (DB2 for iSeries)
DDODBC_MVS.lst (DB2 for z/OS)
The list files are located in the DB2/bind directory in your DataDirect Connect Series for ODBC installation directory. When you bind the list files, if any DataDirect DB2 packages exist, they will be replaced by the new packages. The list files create DB2 packages that, by default, contain 200 dynamic sections and are created in the NULLID collection.
To create DB2 packages by binding list files:
1. Copy the appropriate list (*.lst) file and bind (*.bnd) files located in the /bind directory to a directory on the database server.
2. From the database server directory where you placed the list and bind files, start the DB2 command-line utility. Use the utility to connect to the database where you want to bind the packages. Connect using the following command:
connect to database_name user authorization_name using password
where:
database_name is the name of the database to which you are connecting.
authorization_name is the name of the user you are authenticating to the server.
password is the user's password.
1. Execute the DB2 bind command:
bind @list_file grant public
where list_file is the name of the list file you want to bind.
