Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Apr 2008 @ 23:25:31 GMT

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

Subj:   Re: Duplicate Row Error during an Update
From:   Saxena, Rakesh

Means like while performing the update, teradata was able to identify the same dataset available in the table already and throws out this error if its a set table.

eg: table1

     col1 col2
      1    a
      2    b
      1    b

     update table1
     set col2= a
     where col1 = 1
     and col2 =b

now the data set will look like

     col1 col2
       1   a
       2   b
       1   a(Duplicate record after updation)

IF you have multiset table the probably you can avoid this error.


Rakesh Saxena.

  <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