Archives of the TeradataForum

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

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

<-- 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>>