When is the access path determined for dynamic SQL?
- 2 Answers
- 8388 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 a data page?
How can you quickly find out the number of rows updated after an update statement?
How can you do the explain of a dynamic sql statement?
What is sqlcode -922 ?
Define data page.
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is plan in cobol db2?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
Explain about cursor stability?
What is auditing?
What is the difference between static and dynamic SQL?
what is the soft code for deadlock ?
COBOL 
