Please enable JavaScript to view this site.

ESL Documentation

Navigation: ESL Documentation > ESL DB/Assist > FAQs

Q14 What is Binding?

Scroll Prev Top Next More

Binding is a DB/2 process which optimizes access for each SQL statement in a .SAM by creating a section in the DB/2 system tables  for each statement.  During the DB/Assist compile process, DB/Assist prepares the SQL statements stored in your SAM and will create a section in a bind (.BND) file for each SQL statement that compiles successfully. If none of the SQL statements in the .SAM compile successfully no bind file will be created.  Optionally, if the CREATE PACKAGE  radio button is checked in the BIND OPTIONS dialog, DB/Assist will create an access plan for your SQL statements based on the bind file that was created, thus creating a package. If this option was not selected you can manually issue a DB/2 BIND command, or if the User has sufficient privileges, programmatically use the ESL routine EBD2Bind, to create the Access plan.