How can you do the explain of a dynamic sql statement?


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

Post New Answer

More DB2 Interview Questions

What do you mean by commit and rollback?

0 Answers  


When Can you be sure that a query will return only one row?

4 Answers   IBM,


What is check constraint in db2?

0 Answers  


How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  


What is an intent lock?

3 Answers  






Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  


How to define the data items to receive the fetch items for the SQL?

2 Answers  


What is a trigger in the db2 database?

0 Answers  


in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,


What is the syntax required for the creation of a cursor?

1 Answers  


Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  


Explain the use of the WHERE clause.

2 Answers   IBM,


Categories