|
How do you do the EXPLAIN of a dynamic SQL statement ?
DB2 ( IBM Database 2 ) Interview Questions
(Continued from previous question...)
How do you do the EXPLAIN of a dynamic SQL statement ?
There are two methods to achieve this:
1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement
2.Include EXPLAIN command in the embedded by dynamic SQL statements
(Continued on next question...)
Other Interview Questions
| 