Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

difference between Static and Dynamic Binding

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
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    Post subject: difference between Static and Dynamic Binding
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: 6968
Location: porcelain throne

PostPosted: Tue Jun 28, 2011 8:08 pm    Post subject:
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    Post subject: Reply to: difference between Static and Dynamic Binding
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10275
Location: italy

PostPosted: Tue Jun 28, 2011 8:33 pm    Post subject: Reply to: difference between Static and Dynamic Binding
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    Post subject:
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: 6968
Location: porcelain throne

PostPosted: Tue Jun 28, 2011 9:29 pm    Post subject:
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

Site Director


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

PostPosted: Tue Jun 28, 2011 9:59 pm    Post subject: Reply to: difference between Static and Dynamic Binding
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: 6968
Location: porcelain throne

PostPosted: Wed Jun 29, 2011 1:10 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX - Dynamic file Creation d_sarlie CLIST & REXX 7 Tue Jun 27, 2017 7:30 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us