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