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 does reorg do in db2?
What is syscat in db2?
how to take the back up of the DB2 table.
How many sub queries can you combine together ?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What are the 4 environments which can access DB2 ?
How to resolve -805 error in DB2?
What is a correlated sub query?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What technique is used to retrieve data from more than one table in a single SQL statement?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is DYNSLT keyword? How do you perform selection using DYNSLT