When is the access path determined for dynamic SQL?
- 2 Answers
- 7962 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is db2 plan table?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is universal database?
what is the sqlcode -501
B37 abend during spufi?
Are views updateable?
What is bind in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are union and union all?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Explain package in db2 and its advantages?
What is a buffer in memory?
