What are the functions of Bind?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ms. stanley
To create the most optimal path for the SQL Queries in the
program
| Is This Answer Correct ? | 3 Yes | 0 No |
if i made sme changes in sub pgm wht r the things to be done for this ?
what is static sql? what is dynamic sql? Give me details
wt is view ? wht r the restrictions for view ?
Explain about rct in db2?
What is alias in db2?
how to copy the host variables from ps file into cobol program other than include statement
How to compare data between two tables in db2?
What is db2 stogroup?
wht happens if we close cursor with cursor with hold option?
What is Reorg Recovery? when will you run it?
What does DSNDB07 database do?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?