Archives of the TeradataForum

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

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

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>>