Answer Posted / swetha dasari
there are three things bind does:
1. as stated above, it derives the most optimised path for
each SQL in the DBRM.
2. it does a syntax check. this might sound redundant, but
here is where it refers to the DB2 Catalog and verifies the
table names, column names etc.
3. it checks authorization. here is where it checks if the
user has bind access to the table refered.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the use of with ur in db2?
What is schema in db2?
How many types of page locks can be held in db2?
What is role in db2?
Mention the location where the output received from explain statement is stored.
What is difference between alias and synonym in db2?
What is the use of db2?
What are foreign keys in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is a db2 cursor?
What is the use of db2 optimizer?
What is dbrm in db2 database?
what is a corelated subquerry?
What db2 400?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
