How do you simulate the EXPLAIN of an embedded SQL
statement in SPUFI/QMF? Give an example with a host
variable in WHERE clause)
Answer Posted / s
EXPLAIN PLAN SET QUERYNO = 1
FOR SELECT EMPNO,WORKDEPT
FROM EMP E, DEPT D
WHERE E.EMPNO = D.EMPNO
AND E.EMPNO = ?
Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What is temporal table in db2?
What is package in cobol db2?
What is the physical storage length of timestamp data type?
What is the use of runstats in db2?
How does a cursor work?
How to find the number of rows in db2 tables?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the difference between drop table and delete table?
How do I add a column to a table in db2?
What is db2 instance?
How to find the maximum value in a column in the db2 database?
What is the physical storage length of the data types date, time, and timestamp?
What is the use of db2 optimizer?
What is load utility in db2?
What is bind in db2?