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

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,


Give the name of some fields form sqlca.

0 Answers  


Explain about dbrm.

0 Answers  


What is sqlcode -922 ?

2 Answers  


How do we specify index to include or not during bind process.

0 Answers   Satyam,






Explain the use of the WHERE clause.

2 Answers   IBM,


What is the STOSPACE Utility used for?

1 Answers  


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

2 Answers  


What is concurrency?

0 Answers  


Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  


What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,


What is the role of the data page in the db2 database?

0 Answers  


Categories