Server to parallel

fmartinsferreira · Post by **fmartinsferreira** » Wed May 10, 2006 1:47 pm

Hi!
I'm transforming a Server job to Parallel Job and I have the following command Oconv(Trim(LINK_004.OTHER_AMT),'MD2') that work in a transformer stage and it doesn't work in a parallel job.

I saw that there is a function -> StringtoDecimal(String,Rtype) but the help that I have is very poor.

Can anybody help me?

Additional info -> the input is a string like 112.12 and I need the following output 112.

Regards,

Fernando

us1aslam1us · Post by **us1aslam1us** » Wed May 10, 2006 1:57 pm

fmartinsferreira wrote:Hi!
Additional info -> the input is a string like 112.12 and I need the following output 112.

Try "floor" from the transform functions and that will work for you.

Thanks
Sam

fmartinsferreira · Post by **fmartinsferreira** » Thu May 11, 2006 1:58 pm

Sorry but I don't understand "floor"

Thanks
Fernando

ray.wurlod · Post by **ray.wurlod** » Thu May 11, 2006 2:45 pm

You can select floor() from the expression editor in the parallel Transformer stage. It's the parallel equivalent of the server Int() function, returning the largest integer smaller than its argument.

fmartinsferreira · Post by **fmartinsferreira** » Thu May 11, 2006 3:31 pm

Thank you!

Work very well!

Regards,

Fernando

DSXchange

Server to parallel

Server to parallel

Re: Server to parallel

Re: Server to parallel