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 |
How to execute stored procedures?
How to restart a DB2 program?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is a system catalog table in db2?
What is Call attach facility? How does it work?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What is a db2 package?
What happens in bind step in a db2 program?
What is the difference between Where and Having Clause
Name the lockable units in DB2?
What is the meaning concurrency in the db2 database?