difference between Static and Dynamic Binding

Elixir · Posted: Tue Jun 28, 2011 7:46 pm

Hi,

Kindly let me know the difference between Static and Dynamic Binding.

dbzTHEdinosauer · Posted: Tue Jun 28, 2011 8:08 pm

are you speaking of db2 bind
or
the binder process also known as linkedit?

Elixir · Posted: Tue Jun 28, 2011 8:30 pm

In CICS What is the effect of not binding a Linked program ?

enrico-sorichetti · Posted: Tue Jun 28, 2011 8:33 pm

Elixir · Posted: Tue Jun 28, 2011 8:36 pm

BIND as in DB2

dbzTHEdinosauer · Posted: Tue Jun 28, 2011 9:29 pm

does not matter which environment (batch/cics.....)
if you do not db2 bind a db2 module, it will only receive negative sqlcodes.

dick scherrer · Posted: Tue Jun 28, 2011 9:59 pm

Hello,

dbzTHEdinosauer · Posted: Wed Jun 29, 2011 1:10 am

A Dynamic Bind is a no-such thing.

There are parms that you can set which will request DB2 'rebind' the plan during runtime - prior to execution , but I believe that takes into consideration of changes to the db2 objects.

and there is Dynamic SQL which is 'sql on the fly' which means it has to be bound (runtime - Bind)
but the dynamic refers to the SQL, not the BIND process.

again, specific meaning of terms.........

if i am in error, there are others on the board who will correct my comments.