what is the use of bind parameter, Replace?

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


Please Help Members By Posting Answers For Below Questions

What do you mean by between and in? Is between inclusive of specified range values?

866


How do you find the maximum value in a column in db2?

838


What are host variables in db2?

802


What is a db2 collection?

795


Can there be more than one cursor open for any program?

901


what is a corelated subquerry?

831


What is the role of data manager in the db2 database?

842


How to resolve deadlock issue

18999


define clustering index.

800


What is view db2?

833


What is scrollable cursor in db2?

789


What is null in db2?

752


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1486


What is db2 purescale?

759


How do I start db2 in windows?

790