Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

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

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

What is meant by AUTO COMMIT?

3 Answers  

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

Explain dclgen.

0 Answers  

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  




Describe what a storage group(STOGROUP) is?

2 Answers  

what is a trigger and types of triggers

3 Answers   HSBC,

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

What is cursor stability?

1 Answers  

Which isolation level provides maximum concurrency?

0 Answers  

How can you display the current date & current time ?

7 Answers   Cap Gemini,

What is the use of dclgen in db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories