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

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

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

Check the value stored in SQLERRD(3)

(Continued on next question...)

Other Interview Questions

• When will you chose to run RUNSTATS?
• What is the easiest way to find out which programs are affected by change in a table's structure ??
• What is auditing
• How does DDB2 use multiple table indexes ?
• What are a precompiler?
• What is pagespace?
• What is Maximum number of rows per page
• How to define the data items to receive the fetch items for the SQL?
• What information is used as input to the bind process?
• When is the access path determined for dynamic SQL?
• More...