Error during .dsx Eport

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
Prashantoncyber
Participant
Posts: 108
Joined: Wed Jul 28, 2004 7:15 am

Error during .dsx Eport

Post by Prashantoncyber »

Hi All,

We have newly set up the development box and imported the .dsx from Production Box which we got through administrator.
While importing I came across following error:
1)
Unicode character '0080' appears not to be supported by code page 1252 - ignoring it.
Current line=239219

DSJOB / DFSDUPLDDIMSKUlvldebrcostylekeys / ROOT (Job designs)

"\(80)"
2)However I can see jobs once the import is over.
But getting below error while opening the job

Record rcbload in file DS_STAGETYPES

Can any body suggest why these errors are coming and how to overcome.

thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

0x80 (or 128 in decimal) as a single byte that represents NULL in DataStage, but the Euro symbol in Windows. Did you have code page 1252 set when performing the export?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Prashantoncyber
Participant
Posts: 108
Joined: Wed Jul 28, 2004 7:15 am

Post by Prashantoncyber »

ray.wurlod:0x80 (or 128 in decimal) as a single byte that represents NULL in DataStage, but the Euro symbol in Windows. Did you have code page 1252 set when performing the export?

How to check that code page 1252 is set?
If not set then how to set it?

thanks
[/code][/quote]
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's a Windows setting fundamentally. If you have NLS enabled for DataStage, you set it for the project using Administrator, but can override the map at job design level (even down to individual column level) using Designer.

Check the Character Set reported in the header of the DSX file.
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