Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 11:28:36 GMT

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

Hi,

I think you're correct, the MERGE (and the UPSERT suggested elsewhere) will only perform one operation for each source row - an update or an insert.

Prior to TD 13.10 i think that you have to have two operations, one an UPDATE and the other an INSERT.

On TD 13.10 this requirement could be met by using the TransactionTime Temporal feature, it's exactly what that feature is built for. With that being used your application could simply contain an UPDATE statement and the DBMS will do the Update/Insert for you. There is more to Temporal support than just described here, but it could be very useful for you.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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