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

What is a Foreign Key?

1095

Discuss about db2 bind?

1097

Why cursor is used in db2?

1036

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11674

What is the use of predicate?

1042

What is db2 connect?

1068

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1092

Explain the contention situations caused by locks?

1070

Which command is used to connect to a database in DB2 ? Give the Syntax.

1103

What is alias in db2?

1060

What is a dbrm in db2?

1020

What is the physical storage length of the data types date, time, and timestamp?

1088

What is a db2 cursor?

1055

What os does db2 run on?

981

Define declaration generator (dclgen).

1114