Archives of the TeradataForum
Message Posted: Tue, 01 Apr 2008 @ 23:25:31 GMT
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.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|