Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 May 2005 @ 21:10:42 GMT


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


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

<-- Anonymously Posted: Thursday, May 12, 2005 16:37 -->

How do I do the mload update two times on the same tables. For example I want to do an update like this.

In the update I always want update first_name, but I only want upate last_name if last_name = 'abcd'. I thought I can write two mload updates, but Can i write it in a single mload or do I need to use two different mloads. I am not even sure If I can write the first mload as it is.

     update employee

     set first_name = :first_name,
     last_name = :last_name
     where
     em_id = :em_id
     and
     last_name not in 'abcd'
     ;
     update employee
     set first_name = :first_name
     where
     em_id = :em_id;

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: 27 Dec 2016