EXPLAIN PLAN SET QUERYNO = 1 FOR SELECT EMPNO,WORKDEPT FROM

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

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

How do I delete a table in database?

994

What is bind plan?

1006

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1068

What is the advantage in De-normalizing tables in DB2?

1136

How is deadlock resolved?

1100

What is a system catalog table in db2?

1129

Who uses db2?

995

What is dclgen in db2?

1095

Give a brief description of db2 isolation levels?

1033

What is the role of data manager in the db2 database?

1065

What is db2 look?

985

How to take backup of table in db2?

1032

what are bind concepts in db2 cobol?

1045

What is the maximum No of rows per page?

1028

What is consistency token in db2?

1093