Regular Transformer Issue with convert function

chrisjones · Post by **chrisjones** » Wed Apr 01, 2009 4:32 am

Hi ,
The below function is working fine in Basic Transformer but this job is behaving strange sometimes.

Convert(lkMoveConvertData.LKP_REC,Space(256), lkMoveConvertData.SOURCE_REC)

I tried the same above function in regular transformer but it is not working.Does anyone know the reason why the same convert function is not working in regular transformer.

Thanks,
Chris

v2kmadhav · Post by **v2kmadhav** » Wed Apr 01, 2009 4:41 am

could you please paste the exact error that you get when you try that in a regular transformer.

cheers
VM

chrisjones · Post by **chrisjones** » Wed Apr 01, 2009 4:43 am

Hi ...Thanks for ur reply.

I am not getting any error.Job is running fine but convert function is not working due to some reason.

thamks
Chris

v2kmadhav wrote:could you please paste the exact error that you get when you try that in a regular transformer.

cheers
VM

v2kmadhav · Post by **v2kmadhav** » Wed Apr 01, 2009 4:57 am

I have just tested that... worked fine for me....

v2kmadhav · Post by **v2kmadhav** » Wed Apr 01, 2009 5:13 am

are those two fields coming from two different sources?

if you try joining those two sources and look at the data outside datastage....
do you find them to be identical?

what characters are they?

chrisjones · Post by **chrisjones** » Wed Apr 01, 2009 5:30 am

Only ONE Source.See the sample job structure.My aim is to convert all the special or ASCII Characters coming in source to spaces.

LKP_REC(lookup..All special or ASCII Characters are present in this lkp)
|

|
Source(SOURCE_REC)-----> ---->Transformer--->Target

Thx,
Chris

v2kmadhav wrote:are those two fields coming from two different sources?

if you try joining those two sources and look at the data outside datastage....
do you find them to be identical?

what characters are they?

v2kmadhav · Post by **v2kmadhav** » Wed Apr 01, 2009 6:34 am

cant you just write something like
if col1=col2 then space(256) else col1

chulett · Post by **chulett** » Wed Apr 01, 2009 8:06 am

Perhaps we can approach this from another angle. Rather than saying "convert X to spaces" - what are you expecting the output to be? In other words, what are you expecting to be left after this for your target?