Interested to Buy Any Domain ? << Click Here >> for more details...
When is the access path determined for dynamic SQL?
- 2 Answers
- 9118 Views
- I also Faced
- E-Mail Answers
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 the purpose of the QUIESE Utility?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
Explain what a plan is?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
How does a cursor work?
What is query_cache_limit?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is cursor?
How many databases are there?
What is the difference between group by and order by?
What is ibm db2 used for?
What is the difference between base table and view?
COBOL 
