DSXchange

Hi HemaV,

Your data source is using a different code page than your DataStage environment.

The pound Sterling sign is Hex A3 in the extended characters of the Latin 1 (8859-1) code table (the most commonly used code table). Your source and/or your DataStage environment is using a code table that has assigned a different extended ASCII character for that symbol.

You need to determine the code tables being used and either ensure they are the same by picking a common code page or performing a translation as part of your transformation logic.

Here is a link to the Latin 1 code table. http://cs.stanford.edu/~miles/iso8859.html

Is this the only character that is getting changed?

Rob

Stop dealing with American vendors who think that "#" (Shift-3) is the pound symbol.

Then take Rob's advice.

Why would it sometimes fail? Sounds like the proper solution to me.