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 ibm db2 database?

953

What is the latest version of ibm db2?

1203

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2868

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1033

What do you mean by cursor?

942

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1221

How do I add a column in db2?

1000

How can you classify the locks in db2?

1035

What are catalog tables in db2?

982

How can we read records for specific member in CL? AND rpg?

648

What is db2 purescale?

945

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1230

can all users have the privilage to use the sql statement select * (dml)?

1106

If I have a view which is a join of two or more tables, can this view be updateable?

1086

What is db2 look?

971