NLS setting for Latin 1 and Latin 9 characters

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kannantechno
Participant
Posts: 9
Joined: Tue Feb 16, 2010 1:18 am

NLS setting for Latin 1 and Latin 9 characters

Post by kannantechno »

What is the NLS setting to be used in parallel job to allow Latin 1 and Latin 9 characters while extracting and loading to SQL server 2005 Database.

We tried with option ISO-8859-1 , ISO-8859-15 , UTF-8 for NLS but there was no result,

When we tried with server job as mentioned in the below post, latin characters are visible but one or more normal english characters were replaced with some other special character

viewtopic.php?p=325808&sid=3d3a6229cd38 ... 101d665592

please help on this, we need to do the testing and release to production ASAP
Regards,
Kannan
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

We don't do "urgent" or "ASAP" here. DSXchange is an all-volunteer site whose members post as and when they can.

If it's urgent sign up with your official support provider for priority service, and learn just how expensive "urgent" can be.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply