Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Inserting/Updating same target table simultaneously by multiple sessions without locking
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016