ICONV SERVER/PARALLEL

suresh_dsx · Post by **suresh_dsx** » Wed Apr 16, 2008 5:37 am

Hi,
Source column name/data type/length: customerid/Numeric/2
Server transformer Column derivation: Iconv (DSLink79.customerid,"MD0")
Now I am doing migration from server to parallel.
As I understand from the fourm; ICONV/OCONV functions are only applicable to basic transformer not to the parallel transformer.

Please share with me if is their any related functionality present in the parallel.

I appreciate your help in regards to this.

Thanks and Regards,
Suri

ray.wurlod · Post by **ray.wurlod** » Wed Apr 16, 2008 5:49 am

There is no directly related functionality.

There are many specific conversion functions - read about these in the Parallel Job Developer's Guide

suresh_dsx · Post by **suresh_dsx** » Thu Apr 17, 2008 12:21 am

First i converted the source column into varchar then I used the below string function
Convert('.','',col1)

It is working fine now.

Thanks,
SuRi

ray.wurlod · Post by **ray.wurlod** » Thu Apr 17, 2008 12:47 am

Maybe you could more simply have multiplied by 100.