Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 12:08:36 GMT

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

Subj:   Re: Capturing Updated Rows !
From:   Victor Sokovin

  Has anyone else done this thing in another fashion?  

I for one would use MINUS (ALL). Probably because I am too lazy to write lengthy SQL. Seriously speaking, MINUS is a well-optimized set operation which should give you all the differences on all the columns you specify in SELECTs. Unfortunately, it would not tell which columns exactly differ. You have to do additional processing, if you need that kind of information (apply your lengthy SQL, for example, in the rows returned by the MINUS). Your posting suggests that you don't as row print method would have the same level of feedback.



  <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: 28 Jun 2020