Archives of the TeradataForum

Message Posted: Sun, 05 Apr 2015 @ 11:15:35 GMT

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

<-- Anonymously Posted: Saturday, April 04, 2015 18:56 -->

Hi,

I want to insert/update a target table simultaneously from different TD source (staging) tables via multiple sessions. How can I achieve this? I intend to insert and update the same target table by multiple sessions without locking each other. There is no DELETE operation necessary.

Would using the MERGE statement by multiple sessions to update the same table simultaneously work without locking each other ?

Also, please let me know if a INSERT/SELECT and UPDATE (by multiple sessions simultaneously) would also work ?

Thanks in advance...

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