Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Capturing Updates in a Readable File
 
From:   Maxwell, Donald

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016