Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 17:22:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, March 25, 2004 10:50 -->

Don,

It took a while for me to test the case before saying to you why not possible. What I did was I archived the (after) journal, applied that to an identical empty table. The test contained just 1 insert, 1 update and 1 delete transaction. The insert/update rows were created in the empty table successfully. However No rows for the deleted row (obviously funny). The Roll forward doesn't generate error for the missing delete rows. So unless you have some mechanism to track the deletes you will not be able to apply that to your Non-Teradata database. of-course if you had the row in the log-table to begin with the roll forward would delete it (I tested that scenario as well). Please ask if you want the test examples.

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>