EBCDIC translation problem when fastloading data from mainframe

UDA

EBCDIC translation problem when fastloading data from mainframe


Hello,

I have a mainframe dataset with EBCDIC data that contains NL (NewLine) characters (x'15').

I have a job to fastload this data into teradata. It works fine, except that the NL characters are converted to "Õ"s (x'D5').

I need the NL's (x'15') to be converted to LF's (x'0A') instead of x'D5'.

Can anyone help me with this?

Thanks in advance,
Rafael