Problem while Importing datasteg jobs

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
suchitta_b
Participant
Posts: 4
Joined: Thu Jan 12, 2006 7:02 am

Problem while Importing datasteg jobs

Post by suchitta_b »

Hi All,

We are facing some problem while importing jobs which has Chinese characters in transformation logic. It gives the following errors while importing-
"Error converting hex character '51F3'-ignoring. Current line=Derivation"\(51F3)"" and "Unicode character '51F3' appears not to be supported by code page 936 ignoring it. Current line=450" etc..
We are still able to complete the imports, but after the import is over, the Chinesecharacters are getting replaced by NULL.The client machine has windows OS with Chinese code page set at Regional Language Settings.

As an additional information, we have NLS MS936-CS and MS950-CS mappings set at the datastage server and are able to view Chinese characters in view data mode.
Suchitta
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What are your DataStage NLS settings, both for data processing and for communication with the client?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
suchitta_b
Participant
Posts: 4
Joined: Thu Jan 12, 2006 7:02 am

Post by suchitta_b »

Hi Ray,

We are using the following settings-
At Administrator level- Current ANSI Code Page: 936 ,
Client/Server map in use: MS936-CS.
During data processing at Designer we are using UTF8.
Suchitta
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You say your DataStage server is a UNIX machine. Ought not your character set therefore be BIG5 or GB2312 ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
suchitta_b
Participant
Posts: 4
Joined: Thu Jan 12, 2006 7:02 am

Post by suchitta_b »

Hi Ray,

Our datastage server is SunOS 5.9 sparc.

When we take export of jobs, the dsx file are generated with Charater Set as 'UNICODE'. Do you think if we change the server code page to 936 it will solve the problem?
If so, please tell how to change code page of a Unix server?

Will it effect the other jobs with no special characters?
Suchitta
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

936 is a Windows code page.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
suchitta_b
Participant
Posts: 4
Joined: Thu Jan 12, 2006 7:02 am

Post by suchitta_b »

Please provide a solution to my problem.. :( :(
Suchitta
muruganr117
Participant
Posts: 40
Joined: Sun Jan 21, 2007 1:52 pm
Location: Chennai
Contact:

Did this issue get resolved ?

Post by muruganr117 »

suchitta_b wrote:Please provide a solution to my problem.. :( :(
Hi Suchitta,

Did this issue get resolved ?
We are facing similar problem, it would be of great help if you could provide assistance.

Thank you very much in advance.

regards
Post Reply