How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Giv

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 / guest

2 Answers
8960 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a ..

Answer / 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

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a ..

Answer / raj

Not getting the ans.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More DB2 Interview Questions

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers Accenture,

What parameters are used to control the free space in DB2?

0 Answers

how to resolve -811 sqlcode .give clear explaination

3 Answers IBM,

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers Syntel,

What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers Cap Gemini,

How to retrieve rows from a db2 table in embedded sql?

0 Answers

What is dpf in db2?

0 Answers

What are types of indexes?

0 Answers

how will you retrieve first record in table

1 Answers UST,

What is DCLGEN ?

2 Answers

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers JPMorgan Chase,

What do the initials DDL and DML stand for and what is their meaning?

2 Answers

For more DB2 Interview Questions Click Here