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 is the maximum size of varchar data type in db2?

649


What is null indicator in cobol db2?

595


Give the name of some fields form sqlca.

621


What is db2 plan table?

633


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2390






What is the physical storage length of timestamp data type?

650


What is package in cobol db2?

709


Why do we use cursor?

603


Explain various types of locks in db2?

705


What is node in db2?

613


What is the maximum size of a char data type in db2?

593


Why do chiropractors use drop table?

672


What is bind package and plan in db2?

600


Explain about rct in db2?

649


What is the purpose of using commit?

627