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
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Jun 29, 2011 4:14 am
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DJRH
Premium Member
Posts: 23 Joined: Fri Jul 07, 2006 9:03 am
Location: Mississauga
Post
by DJRH » Wed Jun 29, 2011 4:57 am
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
DJRH
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Jun 29, 2011 5:38 pm
Try setting the NLS map (in the job or in the stage if you prefer) to NONE.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DJRH
Premium Member
Posts: 23 Joined: Fri Jul 07, 2006 9:03 am
Location: Mississauga
Post
by DJRH » Wed Jun 29, 2011 10:24 pm
Hi Ray,
We tried executing by setting job NLS to NONE, still the issue exists.
DJRH
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Jun 30, 2011 2:42 am
Hmm. Have you tried setting the map to ISO8859-1 explicitly in the job or stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Jun 30, 2011 2:45 am
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)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Jul 05, 2011 11:26 pm
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers