Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2007 @ 23:15:54 GMT


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


Subj:   Re: Finding Multiload locks
 
From:   Ureta, Cesar

Here's something you may use:

     LOCKING TABLE table_a FOR WRITE NOWAIT
     sel count( * ) from table_a where table_a_primary_index = -1;

And if it comes back with an error like this: "2574 operation not allowed ... is being mloaded", that means ...


Cheers,

Cesar Ureta



     
  <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: 28 Jun 2020