Archives of the TeradataForum
Message Posted: Sun, 05 Apr 2015 @ 11:15:35 GMT
<-- Anonymously Posted: Saturday, April 04, 2015 18:56 -->
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|