Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 Jun 2000 @ 13:49:24 GMT


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


Subj:   Re: LOCK ROW FOR WRITE in Bteq
 
From:   Barry Hull

Ken,

As long as you have all of the columns of the primary index (doesn't matter if it's NUPI or UPI) of your update specified as "equal to" conditions in the WHERE clause and you haven't overrode the default locking somewhere, this type of operation will automatically do a write lock at the row-hash level. This is true whether it's done through BTEQ or other interfaces (such as ODBC or JDBC).

Barry



     
  <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