|
How do you simulat the EXPLAIN of an embedded SQL statement in SPUFI/QMF ?
DB2 ( IBM Database 2 ) Interview Questions
(Continued from previous question...)
How do you simulat the EXPLAIN of an embedded SQL statement in SPUFI/QMF ?
Q: How do you simulat the EXPLAIN of an embedded SQL statement in SPUFI/QMF ? Give an example with a host variable in where clause) ?
AN:
Use a question mark in place of a host variable (or an unknown value). For instance,
SELECT EMP_NAME FROM EMP WHERE EMP_SALARY > ?
(Continued on next question...)
Other Interview Questions
| 