Archives of the TeradataForum

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

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

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

Thanks

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