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 |
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is null value in db2?
On the create tablespace, what does the CLOSE parameter do?
How does DB2 store NULL physically?
how to check the table is empty or not?
What is a db2 collection?
What is index in db2?
What is universal database?
How can you display the current date & current time ?
Is db2 a database?
What kind of database is db2?
What are delete-connected tables?