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

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

Question Posted / guest

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

More DB2 Interview Questions

How to resolve -803 sql code in DB2?

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

What are the various data types available in db2?

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

What action db2 takes when a program aborts in the middle of a transaction?

What can the Locate option of the Repair Utility accomplish?

How do you run JCL in cobol program

How will you delete duplicate records from a table?

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

What is null indicator in db2?

What are the benefits of using the db2 database?

What is load utility in db2?

For more DB2 Interview Questions Click Here