Interested to Buy Any Domain ? << Click Here >> for more details...
When is the access path determined for dynamic SQL?
- 2 Answers
- 9130 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 |
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is package versioning? Please give an example.
What is the cascade rule and how does it relate to deletions made with a subselect?
What is reorg?
What is an access path?
How do I add a column in db2?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
how to take the back up of the DB2 table.
how to fetch first 100 rows in db2
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
How is a typical db2 batch pgm executed?
What is a DB2 access path?
COBOL 
