Hi, does anyone know how to avoid replicating delete statements?
I have a table in a source database. This table is pruned
occasionally. I'd like to have a copy of this table in a second
database, containing every row that ever existed in the source table.
So, when a "delete from srouce where ..." is execute, that delete is
not replicated, but all other SQL statements against the source table
are.
Is there a sane way to do this with DB2 replication?
Nathan
I have a table in a source database. This table is pruned
occasionally. I'd like to have a copy of this table in a second
database, containing every row that ever existed in the source table.
So, when a "delete from srouce where ..." is execute, that delete is
not replicated, but all other SQL statements against the source table
are.
Is there a sane way to do this with DB2 replication?
Nathan