Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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
     last_name = 'efgh'
     insert into employee
     first_name = :first_name,
     last_name = :last_name;


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