Character set conversion in DataStage job
Posted: Tue Nov 22, 2011 3:18 am
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
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