Page 1 of 1

Error during .dsx Eport

Posted: Fri Oct 06, 2006 12:10 am
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

Posted: Fri Oct 06, 2006 2:25 am
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?

Posted: Sun Oct 08, 2006 8:07 pm
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]

Posted: Sun Oct 08, 2006 10:01 pm
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.