Archives of the TeradataForum

Message Posted: Fri, 22 Mar 2013 @ 12:12:56 GMT

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

<-- Anonymously Posted: Friday, March 22, 2013 05:01 -->

Hi All,

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?

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