Answer Posted / rana
A "BIND REPLACE" will require a DBRM as input and will
replace the existing data with that supplied in the DBRM.
It will then analyse the access paths for the SQL supplied
in the DBRM. You tend to run a "BIND REPLACE" when the
associated application has been updated so that DB2 is also
updated with any changes to the SQL.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is null in db2?
What do you mean by cursor?
Which components manage deadlocks in db2?
Explain in detail about buffer manager and its functionalities?
What is bind in db2?
What is the use of db2 optimizer?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to find the number of rows in a db2 table?
How do I add a column in db2?
What is release/acquire in bind?
What is cobol db2?
What is explain in db2?
Why db2 is called db2?
Give the name of some fields form sqlca.