What is a DB2 bind?



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

Post New Answer

More DB2 Interview Questions

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  


How do you check for a null value in a db2 column?

2 Answers  


How can you display the current date & current time ?

1 Answers   Cap Gemini,


How do I add a column in db2?

0 Answers  


How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,


what is the difference between join and union?

4 Answers   IBM,


Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,


Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  


Define data page.

0 Answers  


what is Static and dynamic linking

1 Answers   Virtusa,


I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  


Categories