Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 28 Jan 2013 @ 10:42:47 GMT


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


Subj:   Re: MERGE Failed 5977: Invalid MERGE-INTO statement
 
From:   A, Surya Kumar

Hi,

Updates on PPI columns are not supported:

UPDATEs of the primary index column(s) are not supported. For PPI tables, this restriction is further extended to not supporting UPDATEs on partitioning column(s) as well.

TRY:

     MERGE INTO   C1
     USING
     (
            SELECT
                  COL1
                 ,COL2
                 ,COL3
                 ,COL4
                 ,COL5
                 ,COL6
                 ,COL7

            FROM 
     ) C2

     ON  C1.COL1 = C2.COL1
     AND C1.COL2 = C2.COL2
     AND C1.COL3 = C2.COL3
     AND C1.COL4 = C2.COL4

     WHEN MATCHED THEN UPDATE
        SET

                 COL6 = C2.COL6
                 ,COL7 = C2.COL7

Thanks,

surya



     
  <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: 23 Jun 2019