DSXchange

We are working with the Russian data that is converted to Cyrillic charecter, how to convert it back(Russian)? I am not sure how the data was converted to Cyrillic. If we can do it in datastage that is well and good, can this be done in Unix?

Thanks for the help.

You need to find out, obviously, how it was converted to Cyrillic characters in the first place (nothing unexpected should happen in ETL). The short answer is that there are character maps between the outside world and DataStage, that convert from and to the external character set.

There is no mechanism whatsoever in DataStage for converting from English to Russian, unless you implement it yourself.

hi,

You could do this in Unix by using iconv function. The syntax for which is as below.
iconv -f <FromSourceCodePage> -t <ToTargetCodePage> <FileNameTobeConverted.txt> > <DestinationFileName>

Thanks & regards
Sudhindra P S

When I did a man iconv on my Linux server it professed ignorance. Does this command come with UNIX or is it something you built yourself?

hi Ray,

iconv command comes with UNIX. Please see documentation for the same in the below mentioned link.
http://www.gnu.org/software/libiconv/do ... onv.1.html

Thanks & regards
Sudhindra P S

But not in the man pages.

Thank you for the link.

Interesting. Iconv and man pages both here under HP-UX.

man pages for the iconv function are present on AIX as well.

Turns out some man pages had been removed, to "save disk space".

Brilliant! Who needs them gi-huge-ic man pages, anywho.

Thanks Guys. Sundhindra's Unix command works great for what we are doing. Appriciate it.