Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Mar 2006 @ 10:58:01 GMT


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


Subj:   Abort a query if it exceeds time limit
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, March 24, 2006 00:11 -->

Hi All,

Using BTEQ as an option, can somebody let me know an option to kill the query if it goes beyond some specified time limit.

So lets say I specify 10 minutes. If the query runtime exceeds 10 minutes, the query should get aborted automatically.

What are the other options available outside BTEQ. I know we can do it using JDBC/ODBC. I do not have a single query but set of queries run in script mode.

Please suggest.


Thanks a lot!



     
  <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