How can you do the explain of a dynamic sql statement?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by commit and rollback?
When Can you be sure that a query will return only one row?
What is check constraint in db2?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
What is an intent lock?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How to define the data items to receive the fetch items for the SQL?
What is a trigger in the db2 database?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is the syntax required for the creation of a cursor?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
Explain the use of the WHERE clause.