Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Problem in MULTILOAD UPSERT
From:   Anomy Anom

<-- 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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023