Archives of the TeradataForum
Message Posted: Thu, 12 May 2005 @ 21:10:42 GMT
<-- 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;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|