Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
suresh_dsx
Participant
Posts: 160 Joined: Tue May 02, 2006 7:49 am
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
suresh_dsx
Participant
Posts: 160 Joined: Tue May 02, 2006 7:49 am
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Apr 17, 2008 12:47 am
Maybe you could more simply have multiplied by 100.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.