why should we bind the DB2 program . What if we did not
BIND a BD2 program ??

Answer Posted / srinivas g

Bind is type of compiler for the SQL statement.
It reads the SQL Statements from the DBRM and produces a mechanism to access data as directed by the SQL statements being bound.
Also checks Syntax, check for correctness of table & column definitions against the catalog information & performs authorization validation.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by commit and rollback?

773


What does db2 mean?

772


What is cloudant database?

839


What is a db2 table?

764


Explain the benefits you can get from mainframe connect?

727


What is a page in db2?

796


What is the maximum number of columns in a db2 table?

980


What are foreign keys in db2?

820


What are the 2 sqlcodes that are returned?

861


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

972


How do you pull up a query which was previously saved in qmf?

897


My sql statement select avg(salary) from emp yields inaccurate results. Why?

852


List some fields from sqlca?

800


What is load utility in db2?

883


What is a bind in db2?

769