NLS Mapping Error

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
SIHM
Premium Member
Premium Member
Posts: 52
Joined: Fri Oct 18, 2013 3:56 am

NLS Mapping Error

Post by SIHM »

I was getting a mapping error when mapping a UTF-8 file to an ISO-8859-1 file.

There were many characters that were not getting translated. This is not surprising given that there are 65536 Unicode characters to 256 ISO 8859.

To avoid getting warnings but replacing untranslatable characters with ?, IBM suggested the following conversion

Line = Oconv(Line,"NLSISO8859-1")
Post Reply