Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 May 2005 @ 15:48:06 GMT


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


Subj:   Re: Using MLoad to update several columns
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, May 13, 2005 11:48 -->

Thanks for the answer.

Also I want ignore some records based on emp_id and do insert for the rest. I am doing the dummy upsert here. But is there a better way.

Here I am ignoring records if last_name = 'efgh' else insert. updating first name to itself does not alter the data, but logically ignored it.

     update employee
     set first_name = first_name
     where emp_id = :emp_id
     and
     last_name = 'efgh'
     ;
     insert into employee
     first_name = :first_name,
     last_name = :last_name;

Thanks



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019