I got a question on net asked by an interviewer that how to simulate the EXPLAIN of an embedded SQL statements in SPUFI/QMF.
Everywhere I got the same answer with same query without any explanation.. (seems like copy-paste nothing else)
Use a question mark in place of a host variable (or an unknown value), e.g.
WHERE EMP_SALARY >?
Can anyone please suggest me on this or explain me how a question mark can simulate EXPLAIN and before that if this answer is correct or not. Actually I was checking Mullin's developers guide.. but I didn't get anything about EXPLAIN on embedded SQL. So please suggest..