Page 1 of 1

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

Posted: Wed Jul 27, 2011 12:10 pm
by Apotluri
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

Posted: Thu Jul 28, 2011 6:20 am
by abhinavagarwal
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

Posted: Thu Jul 28, 2011 11:51 pm
by Apotluri
I think the NLS setting in Stage properties superceeds the NLS setting in Job properties