IN oracle it is set to 'AMERICAN' . Since I have don;t have admin right in datastage, I am not able to view it. But it must be different then in oracle, as I am getting this behaviour
Is this the em-dash or en-dash character? Or is it some other form of character? Arnd's solution is a good one if the right answer is to convert to hyphen. But what if it isn't? What if the users actually need Char(150) in the result?
The fact that View Data can not handle the character should be immaterial. DataStage can happily handle Char(150) and move it through an ETL process. If that's what's needed, that's what you should do.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
The need of my project was to replicate the changed data from one database to other.
I am fetching the delta from Oracle source database and storing it in a dataset in one job. In other job, the dataset is loaded in the target database.
As a result, I don't want any conversion of the data in between
As mentioned before, DataStage will not convert data unless either explicitly told to do so or if an implicit NLS conversion is taking place. As you don't have NLS installed then you should just pass the data through without any conversions.
ArndW,
In fact in my job I am not doing any conversions/transformation.
The data from oracle stage is dumped directly into Dataset. Within the Dataset i am see the char(150) converted to ?.
Even when I peek the values from oracle stage, they are implictly converted