Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 11 Aug 2009 @ 00:49:43 GMT


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


Subj:   How to bypass bad data in Multiload
 
From:   Zhang, Michael

Hi,

we have a daily multiload insert job and a few critical jobs depend on the successful completion of it. This multiload often failed at acquisition phase due to data quality issue.

For example, an unexpected input character appears same as the defined delimiter. Thus it gives an error "Data item too large for field xxx in vartext record number 999" as the second part of input string is regarded as the next column. No rows are inserted into error table as Multiload treats it as critical failure with RC=12.

Currently we have difficulty to filter the source data, so I wonder if in multiload script, there is a way to "bypass" this offending record and complete multiload with lock released and return code as 0 or something similar. Out business people are happy to discard this offending record and need all the dependent jobs complete.

I understand INMOD can filter data, but have no knowledge on C.

We are running TTU8.2, this multiload job runs from MVS


thanks,

Michael



     
  <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