Archives of the TeradataForum
Message Posted: Fri, 13 May 2005 @ 15:48:06 GMT
<-- 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;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|