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 the default page size of buffer pools?
Name some fields from SQLCA.
How do I change the column size in db2?
What is read-only cursor?
how 2 resolve the -311 sqlcode
How do you pull up a query which was previously saved in qmf?
How will fetch last 5 rows from table in db2
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
what is different three logs in DB2?
how do we solve soc 7 and soc4 ?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?