Archives of the TeradataForum

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

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

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.

Regards,

Rakesh Saxena.

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