Archives of the TeradataForum
Message Posted: Mon, 11 Aug 2009 @ 00:49:43 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|