What is a DB2 bind?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning concurrency in the db2 database?

836


What is the advantage in De-normalizing tables in DB2?

930


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

887


What is reorg?

814


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

829


i want to maintain uniqueness on pdf without make lf??????????

1881


what is utility for parm lib

2091


What is the physical storage length of the data types date, time, and timestamp?

844


How many databases are there?

760


Is db2 a database?

725


What is the max length of sqlca?

954


What is a db2 tablespace?

767


How connect db2 database to datastage?

962


How do I add a column to a table in db2?

825


What is the difference between dbm cfg and db cfg file in db2 ?

1243