Hi,

I am on db2 v8.2 udb/aix. Is there any way to find out the number of rows that were affected by running an update sql ? Do i need to create a update trigger to capture this ?

Thanks,
Ravi

GET DIAGNOSTICS SQL-variable-name = ROW_COUNT

or

sqlerrd(3) in SQLCA

If you are running the SQL in a script or from the command line, use the -a option:

db2 -a "update table-name set ........."

This will show the SQLCA and the number of rows affected in insert, update, or delete is in sqlerrd(3). Does not show rows selected.

select count(*) from final table (update ...)

b.t.w. as far as I know there is no way to determine the number of rows affected if a DELETE also throws rows away because of a "DELETE CASCADE" rule. Am I correct?

Tks for the suggestions - it works fine for what i am trying to do here .