There is nothing built into DataStage that does this. There are a number of freeware/public domain entries to be found for "convert integer to words c++" on Google, and the documentation shows how to create buildops and call them from DataStage.
ArndW wrote:There is nothing built into DataStage that does this. There are a number of freeware/public domain entries to be found for "convert integer to words c++" on Google, and the documentation shows how to create buildops and call them from DataStage.
Thanks Andrw........Can we achieve this through shell scripting? or we need write c++ code only.
If you search the web for a freeware program that does this on your platform, i.e. one that accepts a number as parameter and returns a string representation, then you can implement it via a shell script. Note that if performance is a factor then you will have to use a c++ call.