DSXchange

Hi,

We are trying to read files wich we get from MF by FTP process

The problem is that these files contain a lot of unreadble characters
which produces the following warning:

nls_read_fixedwidth() - NLS mapping error, row 14306 (approx), data = " ???? ???? ?

After fixing the unreadble character fews days later we get another file
with other unreadble characters.

I'm looking for a solution wich will prevent any more mapping errors
because it's very difficult to maintain these very frequent errors.

Is there a proper way to handle mapping errors like these or do we
have to rely only on MF programmers and demand clean files
(MF programers insist they can not predict every
problematic character because the users themselfs can write
in the data whatever they want)

On the FTP-way from one Operating System to an other operating System Errors can occur because they have different ways to store. DataStage is able to correct errors.

Best way is to let transfer files that way that a file is readable with any tool in the target operating system. Therefor those who make the transfer have to use the correct commands for their transfer.