After you capture the SQL statements in your .NET application, you bind the statements that use a given database to a version of the database that is associated with a specific data connection. You must bind each of the captured SQL (.capt) files in a separate bind process.

Note:  If you are using IBM^® Data Server Driver Package instead of IBM Data Server Client or IBM Data Server Runtime Client, you cannot bind your SQL statements in the add-ins. You must bind the packages on your remote database.

Prerequisites:

• To bind SQL statements, you must have privileges that are appropriate for your data server. Refer to the information in the following topics in the data server information centers:
  • "BIND command"  (DB2^® Database for Linux^®, UNIX^®, and Windows^®)
  • "Privileges required for handling plans and packages"  (DB2 for z/OS^®)
• The file that contains the captured SQL statements must be open in the Captured SQL Files viewer.

To bind captured SQL statements in a package:

1. In the Captured SQL Files viewer, click Bind Options.

   The Captured SQL Bind Options window opens.

2. Set the options to use for binding the SQL to the database.

   Tip:  For the PKLIST option, select the collection ID check boxes in the order that you want the collections to occur in the package list. This order can affect the runtime performance of your application program.

3. Click OK in the Captured SQL Bind Options window.

   The value of the TEXT field in the BINDOPTIONS section of the captured SQL file is updated with the string of bind options that you set.

4. In the Captured SQL Files viewer, review the connection that is selected in the Connection list. If necessary, select a different connection, or click New to define a new data connection.

   The package that contains the static SQL must be bound to the database that the application uses.

5. Click Create Package.

The DB2 db2cap utility is called and the open captured SQL file and corresponding connection information is passed to the utility.

The captured SQL is bound to the database that is associated with the connection that is selected in the Captured SQL Files viewer, and the package is created. Confirmation of the successful bind operation and package creation is shown in the IBM Output Message Pane.

See Also

Improving Performance and Security in .NET Applications with Static SQL | Using Static SQL in .NET Applications | Reviewing Captured SQL Statements | Running .NET Applications with Static SQL

.NET Development Forum   DB2 FAQs

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