Archives of the TeradataForum
Message Posted: Thu, 25 Mar 2004 @ 21:44:21 GMT
I believe there is only one journal, with BEFORE and AFTER options that can be specified together.
I think you would take the hourly journal and apply a ROLLBACK against the empty "before" table. Then, using the same journal, you would apply a ROLLFORWARD into the empty "after" table.
Rows in the "before" table, but not in the "after" table, have been deleted.
Rows in both tables have been updated.
Rows in the "after" table, but not in the "before" table, have been inserted.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|