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 bind in db2?
What is the difference between drop table and delete table?
What language is db2 written in?
What are bind parameters in db2?
What is buffer pool and list some of them?
What is dclgen in db2?
What os does db2 run on?
What are concurrency issues?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is dclgen (declaration generator)?
What is the difference between spufi and qmf?
Explain the function of data manager.
can all users have the privilage to use the sql statement select * (dml)?
What is data manager?