DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

How do you simulate the EXPLAIN of an embedded S

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)

Use a question mark in place of a host variable ( or an unknown value ). e.g.
SELECT EMP_NAME
FROM EMP
WHERE EMP_SALARY > ?

(Continued on next question...)

Other Job Interview Questions