DSXchange

Hi,

We are getting below warning in the datastage parallel job

Job is having one ODBC stage(gets data from SQL server) and a tranformer(does stringtodate of a job parameter) and a Oracle enterprise stage to truncate and load records into a oracle table.
I have removed the Stringtodate conversion and tried executing the job, but still iam getting the warning.

Let me know the possible solution for this.

Thanks in advance
Sri

Set $APT_DISABLE_COMBINATION to 'True'and try to run the job.

You have a character in your data which is not mappable in the IBM-1051 character set.

Hi Gssr,

I Set $APT_DISABLE_COMBINATION to 'True' and re-run the job but still getting the same error


sri

Disabling combination will tell you in which stage you are getting the error, but in this case it will be output enterprise stage.

Hi ArndW,

How can we overcome this issue?
Removing the non-mappable characters of IBM-1051 character set from the source data, is the only solution? or can we deal this in datastage job?

Thanks,
Sri

Hi All,

Is there is any way not to get this warning? I mean can we do some conversion on the columns having special characters? if yes, how can we do that?


Thanks
Sri

Try to discover which character(s) can not be mapped (is it into or out of?) the IBM-1051 character set.

If you correctly define your character sets in source and target then you won't get conversion errors. Odds are you have incorrectly declared your NLS settings in the SQL server source stage.

The NLS setting in SQL server stage and Oracle stage is same - Project default(ISO-8859-1)

And i dont see any NLS option "ibm-1051" in any of the stages.

If both the NLS settings are same why I am getting this warning?

Any possible solution to avoid these warnings?

(Sorry for the late post )

Thanks

What are your UNIX runtime settings for NLS_LANG (check your director output for the value)?

I checked in Director log the value is

Thanks