Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Nov 2005 @ 13:22:16 GMT


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


Subj:   Re: Error handling in BTEQ ???
 
From:   David Wellman

Hi Srikanth,

In this scenario no you can't get any details of the failing row. The entire insert fails because it's a single request and like all/most DBMS's Teradata will enforce the following rule: "the entire transaction works or it all fails".

There is no way (that I've heard of) of finding out which row failed on an insert/select. You would either have to execute another request 'up front' which checks for invalid data or you'll have to export the data and then load it with Multiload or Fastload and use the error tables. Both approaches have their downsides.


Regards,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )



     
  <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