Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Nov 2005 @ 12:41:46 GMT


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


Subj:   Error handling in BTEQ ???
 
From:   Srikanth Sundara

Hi Friends,

I need to implement error handling in BTEQ scripts which will be executed from UNIX. I have a case where I execute an ins-sel "insert into tbl1 sel * from tbl2" in one of the scripts. Even if one of the rows which are supposed to be inserted by this has invalid data, the task fails without inserting any of the rows.

Is there any way by which I could get the details of the rows which are rejected due to which the whole operation fails ????

Please help me out in this.


Regards,

Srikanth S.M.



     
  <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