Archives of the TeradataForum
Message Posted: Fri, 22 Mar 2013 @ 12:12:56 GMT
<-- Anonymously Posted: Friday, March 22, 2013 05:01 -->
I have a file which I want to multiload in a SET table where
1. If column A in table and the same column value in file are same but column B value is different in the file than in table, then update that record 2. If the complete record is same in the file as it is in the table, then ignore 3. If a record in file is having new value for column A then insert into that table
I am using IGNORE DUPLICATE INSERT ROWS but still I am getting a UV table after successful completion of process.
Table -> Column A Column B? Column C Insert_dt Update_dt UPI NUPI NUPI NUPI NUPI Update table set B = :B, Update_dt = current_timestamp(0) where A = :A and B <> :B; Insert into table (:A, :B, :C, current_timestamp(0), current_timestamp(0));
UV table is getting created with NULL values for all the columns in records.
Can you please help me with this? Why this is happening?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|