Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Nov 2007 @ 22:59:54 GMT


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


Subj:   Re: Statistics in BT; ET;
 
From:   ravivijay.kumar

Te set of statements will hold locks after each statements in BT ET mode until it encounters ET. so this might be the reason for your error.

you can refer to below statement in RDBMS SQL reference for better understanding.

Although you can enter a multistatement operation interactively using an explicit transaction (either BT/ET or COMMIT), a better practice is to define such an operation as a macro because an explicit transaction holds locks placed on objects by statements in the transaction until the statement sequence is completed with an END TRANSACTION or COMMIT statement.


Hope this help.


Thanks,

Vijay



     
  <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