When is the access path determined for dynamic SQL?
Answers were Sorted based on User's Feedback
Answer / s
The dynamic SQL is prepared at run time and the access path
is determined at execution time. Dynamic SQL changes from
one execution to another.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kamalakar
At runtime when the PREPARE statement is issued.
Is This Answer Correct ? | 3 Yes | 0 No |
What is concurrency?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is the difference between drop table and delete table?
Can any one tell me about Restart logic in DB2.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What are the contents of a DCLGEN?
How is deadlock resolved?
define clustering index.
What is reorg in database?
Are views updateable?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is db2 connect?