When is the access path determined for dynamic SQL?
Answer Posted / kamalakar
At runtime when the PREPARE statement is issued.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between plan and package in db2?
Explain what are the various isolation levels possible?
What is consistency token in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is precompiler in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How does cobol compile db2 program?
Mention some fields that are a part of sqlca.
What is db2 stogroup?
What is null indicator in cobol db2?
What is deadlock in db2?
What is blu acceleration in db2?
What is reorg and runstats in db2?
B37 abend during spufi?