Page 1 of 1
Posted: Wed Jun 29, 2011 4:14 am
by ray.wurlod
What was the NLS setting in the previous project? How did you move the hashed files? Is there a non-default NLS setting in the job?
Posted: Wed Jun 29, 2011 4:57 am
by DJRH
Hi Ray,
In version 7.1 Windows OS the NLS is not there.
we copied the hashed files from 7.1 to 8.5 through winSCP in binary mode and processed it using fnuxi command
and the default nls setting is ISO 8859-1 for the job
Thank u
Posted: Wed Jun 29, 2011 5:38 pm
by ray.wurlod
Try setting the NLS map (in the job or in the stage if you prefer) to NONE.
Posted: Wed Jun 29, 2011 10:24 pm
by DJRH
Hi Ray,
We tried executing by setting job NLS to NONE, still the issue exists.
Posted: Thu Jun 30, 2011 2:42 am
by ray.wurlod
Hmm. Have you tried setting the map to ISO8859-1 explicitly in the job or stage?
Posted: Thu Jun 30, 2011 2:45 am
by ray.wurlod
One we should have asked at the top.
Is the character being passed through accurately and only being misreported in View Data? That is, is the character correct in the target which viewed with something other than DataStage data browser (which is notoriously bad at "un-American" characters in version 8)?
Posted: Tue Jul 05, 2011 11:26 pm
by chulett
You do realize that you've just repeated information you've already posted and didn't address at all the question that Ray asked you, yes?
