Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 06 Apr 2015 @ 12:18:15 GMT

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

Subj:   Re: Updating via view concurrently
From:   Dave Wellman


This really depends on what type of lock is being placed on the target table.

If the lock is a table-level lock then the answer is "No".

If the lock is a row hash lock then the answer is "Yes".

Explain the query to find the lock type.

Note that the use of a view is irrelevant here. It is the type of lock that counts.



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

  <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: 15 Jun 2023