How do you simulate the explain of an embedded sql statement in spufi/qmf?


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

Post New Answer

More DB2 Interview Questions

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,


How do I import a csv file into db2?

0 Answers  


How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  


what is REORG? what is the use?

4 Answers  


Are views updatable ?

4 Answers  


can we drop column from a table

7 Answers   INDUS,


what is a collection?

2 Answers  


How to update more then one record using update?

5 Answers   IBM,


How can you get the number of rows impacted by the last executed query?

1 Answers  


Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,


Explain how can you do the explain of a dynamic sql statement?

0 Answers  


Categories