how to bypass bad record in Multiload

Tools
Enthusiast

how to bypass bad record in Multiload

Hi,

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

thanks,
Michael
Tags (1)
4 REPLIES
Enthusiast

Re: how to bypass bad record in Multiload

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.)
Teradata Employee

Re: how to bypass bad record in Multiload

If you're using FORMAT VARTEXT, you can add NOSTOP option in IMPORT command.

It is documented in the manual:

NOSTOP: Optional keyword specification that inhibits the MultiLoad termination in response to an error
condition associated with a variable-length text record
Enthusiast

Re: how to bypass bad record in Multiload

Thanks for that. NOSTOP works for me.
Enthusiast

Re: how to bypass bad record in Multiload

Could you people explain me NOSTOP option in MLOAD??