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...

why should we bind the DB2 program . What if we did not
BIND a BD2 program ??

Answer Posted / sangeetha

A bind plan contains the optimised access path to the DB2
resources for the application program.
Hence,the SQLs within the program will fail,if the
application program is not bound with a plan.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1064


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

1104


Explain about rct.

1036


What is alias in db2?

999


What is plan in cobol db2?

1072


How do you eliminate duplicate values in db2?

1118


What is a db2 tablespace?

1009


What are host variables in db2?

996


Give a brief description of db2 isolation levels?

1022


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3533


Define db2.

1069


What is the difference between plan and package in db2?

1052


What is check constraint. Explain with example.

1051


What is difference between isnull and coalesce?

1016


What is a db2 cursor?

1011