How can you quickly find out the number of rows updated
after an update statement?



How can you quickly find out the number of rows updated after an update statement?..

Answer / vamshi

check for the value is in sqlerrd(3). it contains the no.
of rows updates.

Is This Answer Correct ?    23 Yes 0 No

Post New Answer

More DB2 Interview Questions

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


How to create backup table in db2?

0 Answers  


My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,


What is a DB2 catalog?

2 Answers  






List out the three types of page locks that can be held.

0 Answers  


How to select the duplicate rows from a table?

4 Answers  


What are the bind parameters ibm db2?

0 Answers  


i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


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

2 Answers  


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


What is meant by index cardinality?

2 Answers  


Categories