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 |
Give the name of some fields form sqlca.
What is universal database?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
what is a collection?
what is difference between Plan and Package
what is the use of bind parameter, Replace?
What is runstats utility in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
difference between group clause and order clause
How can we define a table? How can we apply SEARCH ALL on it ?
When DB2 connection fails, will online program work or give errors.
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM