Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104


What is null in db2?

1026


What do you mean by cursor?

988


Which components manage deadlocks in db2?

1071


Explain in detail about buffer manager and its functionalities?

1065


What is bind in db2?

1042


What is the use of db2 optimizer?

1117


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1148


How to find the number of rows in a db2 table?

1120


How do I add a column in db2?

1048


What is release/acquire in bind?

1106


What is cobol db2?

1001


What is explain in db2?

1022


Why db2 is called db2?

1041


Give the name of some fields form sqlca.

1079