I am running scheduled tasks in Task center that frequently updates / inserts data from one table to another.

The queries are simple insert /update statements.

I need to know wheter it is possible to know how many rows have been updated / inserted. Currently i only get the following command on insert
DB20000I The SQL command completed successfully.

have you tried the get diagnostics command

Try also and similarly for updates.

This would effectively mean i am running the query twice on the same table.... i guess for this a simple count statement would have also sufficed along with the insert /update following it.... for large table this will be a slow process

well i tried this angle.... but i guess you need to store the value of this register somewhere which is not possible in a command editor kind of environment

Not at all: a "SELECT from FINAL TABLE" will query the rows being added to the table while doing the INSERT, so no double work at all.

By the way: this "select from insert" syntax also gives you the possibility to find out which were the default values and/or identity column values being inserted.

Example: suppose table1 has columns (ID, NAME), where ID is the PK, an identity column.
would return me the PK of the row that I just inserted; very difficult to find out which it was otherwise!
This clearly does *not* query the base table twice: the SELECT just interrogates the single row inserted into table1, just after the row to be inserted has been fully built up.

my mistake.... i did not check the values correctly... it is indeed inserting records as well.... thanks for that....

is there anyway i can log this record into my disk??....my db2 is currently on an AIX setup