why should we bind the DB2 program . What if we did not
BIND a BD2 program ??
Answer Posted / sangeetha
A bind plan contains the optimised access path to the DB2
resources for the application program.
Hence,the SQLs within the program will fail,if the
application program is not bound with a plan.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Explain about rct.
What is alias in db2?
What is plan in cobol db2?
How do you eliminate duplicate values in db2?
What is a db2 tablespace?
What are host variables in db2?
Give a brief description of db2 isolation levels?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Define db2.
What is the difference between plan and package in db2?
What is check constraint. Explain with example.
What is difference between isnull and coalesce?
What is a db2 cursor?