Mention the location where the output received from explain statement is stored.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is difference between rollback and commit?

0 Answers  


What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


What is a cursor in programming?

0 Answers  


How to fetch the last row from the table in SQL (db2)?

0 Answers  






In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,


What is meant by isolation level?

3 Answers  


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

2 Answers  


How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,


What is a clustering index ?

3 Answers  


What is db2?

0 Answers  


the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,


Categories