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 a DB2 bind?



What is a DB2 bind?..

Answer / tintu raveendran

It is the process of creating an executable module from the
source DBRM. Its functions are,
Checks the syntax of the SQL defined in the program (DBRM)
Checks whether the object accessed by the SQL physically
exists.
Does an authorization check.
Creates the optimum access path for the query using the
DB2 optimizer.

Is This Answer Correct ?    8 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is tablespace?

3 Answers  


What is an alias and how does it differ from a synonym?

3 Answers  


what is sql abend code -801,-802?

2 Answers  


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,


What is the use of predicate?

0 Answers  


db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,


how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,


What is the purpose of rollback and commit?

0 Answers  


Which transaction use a command thread ?

1 Answers  


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,


Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,


Categories