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 are the 2 sqlcodes that are returned?
What is sqlca’s maximum length?
What are the different types of base tables?
List out the buffer pools in db2
what is utility for parm lib
What is the physical storage length of date data type?
Can there be more than one cursor open for any program?
What is db2 and what is the use of db2 optimizer?
How to resolve deadlock issue
Is the primary key a clustered index?
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?
What is nvl in db2?
What are catalog tables in db2?
What is db2 optimizer?
What is declare cursor?