Converting UTF-16 file to UTF-8 using Datastage job

Apotluri · Post by **Apotluri** » Wed Jul 27, 2011 12:10 pm

Looking for a solution for below scenario

Recieving source file in UTF-16 format and need to give target file in UTF-8 format. The source file may contain double byte characters like Chinese characters
I know converting the file format using unix command, but want to do that using in DataStage job ( without using unix)
I tried keeping NLS of source file ( sequential file stage) in UTF-16 and then tried to create target file ( sequential file stage) by keeping NLS as UTF-8, but in vain..
any suggestions would be helpful...

Thanks in advance

abhinavagarwal · Post by **abhinavagarwal** » Thu Jul 28, 2011 6:20 am

Try to set NLS at job level to UTF-8 rather then at stage level ..... do not worry about the soruce UTF - 8 at source .... there will be no data loss if you will read it while job level NLS UTF - 8

Apotluri · Post by **Apotluri** » Thu Jul 28, 2011 11:51 pm

I think the NLS setting in Stage properties superceeds the NLS setting in Job properties