we have a daily multiload insert job and a few critical jobs depend on the successful completion of it. This multiload often failed due to data issue e.g. unexpected input charactor appears same as delimiter. Currently we have difficulty to filter the source data, so I wonder if in multiload script, there is a way to "bypass" the offending records and complete multiload with lock released and return code as 0 or something similar.
I understand INMOD can filter data before multiload, but have no knowledge on C.
We are runing TD8.2, this mutiload job runs from MVS
If you extract/ load the data as fixed width, instead of character delimited, yu do not have the same problem. The only other approach is to change your delimiter to something which does not or cannot appear in the input data - like X'1F' (See the old Teradata forum for details of this.)