Results 1 to 3 of 3

Thread: Bind in DB2 UDB

  1. #1
    Join Date
    Jun 2005

    Unanswered: Bind in DB2 UDB


    I am new to db2. Can any one explain me what is Bind in db2 udb?
    why is it Used for?
    if possible please explain me with a small example.

    your help is really appreciated

    Thanks in Advance.

  2. #2
    Join Date
    Nov 2004


    The bind procedure is for static programming with DB2 calls.
    The sql code is extracted from the source, prepared and saved in the database.This gives the advantage that the plan definition/authorities don't have to be created for each executing, but is done once.
    There is still a relation between the executable module and the bind file.
    For more details, see the application programming guide...
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

  3. #3
    Join Date
    Apr 2004
    The main feature of Static SQL is that the query plan is stable, and is known before statement is being invoked. The one is formed at bind time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts