Routine or Transform, which one wins

WoMaWil · Post by **WoMaWil** » Tue May 15, 2007 7:00 am

When having a Routine and a Transform with the same Name and number of parameters in a Job-Derivation, the Transform wins.

Is there a way to force the Derivation to call the Routine?

chulett · Post by **chulett** » Tue May 15, 2007 7:24 am

I don't think so, but we'll have to see what one of the Uber Gurus has to say on the subject.

ray.wurlod · Post by **ray.wurlod** » Tue May 15, 2007 4:32 pm

It is not possible.

In this situation (a Transform and a Routine with the same name) the Transform is always selected.

This harks back to the earliest versions of DataStage, where the only available way to invoke a Routine was via a Transform; often they had the same name.

I guess it's been kept that way to ensure backwards compatibility.

Might be worth an enhancement request to add a switch with which you might control this behaviour, if it's important to you.

WoMaWil · Post by **WoMaWil** » Wed May 23, 2007 1:18 am

Thank you Ray for the answer, even though I am not able to read the complete answer nor to set this question on resolved.

chulett · Post by **chulett** » Wed May 23, 2007 6:58 am

He expands on his answer, but the bottom line is still 'no'.

kduke · Post by **kduke** » Wed May 23, 2007 7:10 am

Did Craig call Ray a Uber? I don't think I would take that Ray.

chulett · Post by **chulett** » Wed May 23, 2007 7:12 am

I went fishing for an Uber, can't help who takes the hook.

ray.wurlod · Post by **ray.wurlod** » Wed May 23, 2007 2:51 pm

Wolfgang, you need to get in touch with Walter (the webmaster) because of the problem with not being able to set the status to Resolved.

As to the rest of the answer, think back prior to version 3.0 - I know you were there!

kduke · Post by **kduke** » Wed May 23, 2007 11:01 pm

It takes a bigger Uber than me to take this bait.