Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 21:44:21 GMT

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

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.

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