hi,

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.

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...

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.