IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

difference between Static and Dynamic Binding


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Elixir

Active User


Joined: 08 Feb 2009
Posts: 116
Location: CHENNAI/NEW JERSEY - INDIA/USA

PostPosted: Tue Jun 28, 2011 7:46 pm
Reply with quote

Hi,

Kindly let me know the difference between Static and Dynamic Binding.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jun 28, 2011 8:08 pm
Reply with quote

are you speaking of db2 bind
or
the binder process also known as linkedit?
Back to top
View user's profile Send private message
Elixir

Active User


Joined: 08 Feb 2009
Posts: 116
Location: CHENNAI/NEW JERSEY - INDIA/USA

PostPosted: Tue Jun 28, 2011 8:30 pm
Reply with quote

In CICS What is the effect of not binding a Linked program ?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10876
Location: italy

PostPosted: Tue Jun 28, 2011 8:33 pm
Reply with quote

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


ANSWER THE PREVIOUS QUESTION ...
BIND as in DB2
BINDER as the NEW LINKAGE EDITOR ?
Back to top
View user's profile Send private message
Elixir

Active User


Joined: 08 Feb 2009
Posts: 116
Location: CHENNAI/NEW JERSEY - INDIA/USA

PostPosted: Tue Jun 28, 2011 8:36 pm
Reply with quote

BIND as in DB2
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jun 28, 2011 9:29 pm
Reply with quote

does not matter which environment (batch/cics.....)
if you do not db2 bind a db2 module, it will only receive negative sqlcodes.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Tue Jun 28, 2011 9:59 pm
Reply with quote

Hello,

Quote:
Kindly let me know the difference between Static and Dynamic Binding.
Quote:
In CICS What is the effect of not binding a Linked program ?
Quote:
BIND as in DB2

Was there ever an actual question here. . . . icon_confused.gif

Was there a bit of spare time and the thought occurred to toss something at the forum?

Must be the summer doldrums again. . .

d
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jun 29, 2011 1:10 am
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Difference between PLT txn and schedu... CICS 3
No new posts Using Dynamic file handler in the Fil... COBOL Programming 2
No new posts JCL Dynamic System Symbols JCL & VSAM 3
No new posts Timestamp difference and its average ... DB2 11
No new posts Synctool-dynamic split job for varyin... JCL & VSAM 7
Search our Forums:

Back to Top