Hi,
My job is reading data from Oracle DB in Western European character set and writes it to a flat file.
Now in another job I want to read this file and write the data to another file through a transformer in between, but in UTF8 character set this time. I tried changing the NLS map to UTF8 in the target sequential file but didn't work. The characters in o/p file are not same as i/p file, mainly special characters.
Please let me know if this is possible to convert character set of data on the fly in a DS job.
Thanks,
Shashank
Character set conversion in DataStage job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In general, no. The only yes is where the character sets are compatible and, even then, you may need Oconv(string,NLSmapname) type conversions for non-numeric data. What character set are you using on the DataStage input?
Do you have any locale-related specificities, such as date formats, currency, decimal representations, casing conventions, etc? All these can also be handled by setting the NLS locale, if not for the job then at least for the Transformer stage.
Do you have any locale-related specificities, such as date formats, currency, decimal representations, casing conventions, etc? All these can also be handled by setting the NLS locale, if not for the job then at least for the Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.