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 |
What is cloudant database?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
select 100 records from million records ?
What is a collection?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
Is it possible using max on a char column?
What is the use of value function?
What is meant by isolation level?
what is load and unload in db2
What is declare cursor?
What is difference between rollback and commit?