Explain what a plan is?
Answers were Sorted based on User's Feedback
Answer / bhavna
A plan is an executable module containing the access path
produced by DB2 optimizer.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
An application program cannot run without a plan. A Plan is
created by BIND PLAN, by binding DBRMS, packages or DBRMS
and packages together.
| Is This Answer Correct ? | 1 Yes | 3 No |
what is load and unload in db2
How to rename a table in DB2 ?
What is difference between alias and synonym in db2?
B37 abend during spufi?
Why do we use cursor?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Explain db2.
Update command
What is dclgen in db2?
Can there be more than one cursor open for any program?
How do I create a view in db2?