Home Page for the TeradataForum
 
 

 

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 Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 09 Nov 2008