Hello Team,

I need information on an UPDATE statement. Is there a possibility to UPDATE a set of rows based on the range of timestamp they have been INSERTed?

For example,

I want to UPDATE the rows which were INSERTed between
2008-01-01-00.00.00.000000 and 2008-12-31-00.00.00.000000

Can you please assist me here.

Thank you.

Hi,

UPDATE - IBM DB2 9.7 for Linux, UNIX, and Windows

update <TABLE> set <COLUMN_YOU_WANT_TO_UPDATE> = NEW_VALUE where <TIMESTAMP_COLUMN> between '2008-01-01-00.00.00.000000' and '2008-12-31-00.00.00.000000'

If you update to many rows at once, you might blow your Transactionlog.

That <TIMESTAMP_COLUMN> should of course already be in that table, and it should have been declared
"WITH DEFAULT"
If not, there is no way to ever find out when precisely a row had been inserted into the table.

Hi team..
thanks for the information..

If <TIMESTAMP_COLUMN> this column is not defined in the concerned table, then how do a USER go with updating his table for this requirement ?

Do anyone know, if such kind of situation exists with other users? Updating rows based on INSERT timestamps..?

thank you