NLS mapping errors

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ZEEVS1970
Participant
Posts: 6
Joined: Wed Mar 08, 2006 5:57 am

NLS mapping errors

Post by ZEEVS1970 »

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)
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

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.
Wolfgang Hürter
Amsterdam
Post Reply