Answer Posted / siri
BIND CAN HAPPEN TWO PROCESS...ONE IS PACKAGE...ANOTHER ONE IS PLAN....PLAN IS EXCUTABLE....WE BIND DBRM TO PACKAGE AND THEN INTO THE PLAN....WE BIND DIRECTLY DBRM TO PLAN...ONE DBRM IS CREATED FOR ONE PROGRAM....IN 10 DBRMS WE BIND INTO THE PLAN...IN 10 TIMES WE BIND INTO THE PLAN...IN CASE OF PACKAGE 10 DBRMS ARE BIND INTO THE PACKAGE AND THEN INTO THE PLAN ITS NO NEED TO BIND 10 TIMES..10 PACKAGES ARE INCLUDED IN ONE PACKAGE LIST..WE BIND ONE PACKAGE INTO THE PLAN AUTOMATICALLY 9 PACKAGES ARE BIND...PLAN IS EXCUTABLE...MEANS IT IS EXCUTABLE WITH LOAD MODULE...PLAN TIME STAMP TOKEN AND LOAD MODULE TIME STAMP TOKEN IF IT MATCH..THE PROGRAM IS EXCUTED...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How does a cursor work?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is scrollable cursor in db2?
What are the contents of a dclmgen?
What is precompiler in db2?
What is the difference between bind and rebind in db2?
What is dbrm library?
What is the maximum size of a char data type in db2?
Is it possible using max on a char column?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Why select is not preferred in embedded sql programs?
What is the difference between cursor stability and repeatable read isolation levels?
How to create backup table in db2?
What are db2 tables?
How many types of page locks can be held in db2?
