Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 18 Jun 2008 @ 17:57:48 GMT


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


Subj:   Re: V12, MERGE Logic: 1) Restriction inserts; 2) PPI behavior
 
From:   Victor Sokovin

          > Query B inserts all the rows of the source into the target. (partition
          > specific logic is ignored. The explain reflects this.)
          >
          > /*** Query B ***/
          >
          > database wlg35507_temp ;
          >
          > MERGE INTO wlg35507_temp.table_mvc_idx  bb
          > USING wlg35507_temp.table_tst   aa
          > ON aa.PI_attr = bb.PI_attr
          > and aa.partitioning_attr = bb.partitioning_attr
          > and (aa.partitioning_attr between 8736 and 8766
          >    or xx.partitioning_attr between 8249 and 7679
          >    or xx partitioning_attr between 7672 and 7702 )
          >
          >
          > WHEN NOT MATCHED THEN
          > Insert (
          >   aa.attr01
          > ,aa.attr02
          >     ...
          > ,aa.attr_last
          > )
          > ;

Bill, you may need to check the syntax, or the syntax you posted is not the same as what you describe.

What is the exact definition of xx in the above query, for example?

What are the UPDATEs you are talking about? You did not post them.


Victor



     
  <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