DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions
How do you simulat the EXPLAIN of an embedded SQ
More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions