Equivalent of Translate fn which can be used on Modify Stage

Sagnik Mukherjee · Post by **Sagnik Mukherjee** » Tue Dec 04, 2012 2:51 am

Could someone please suggest the equivalent function of Translate function,which I can use on modifyspec of modify stage?
Please suggest function with its full syntax.
Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 04, 2012 2:53 am

What does the Translate() function do? It's not a function that's built into DataStage.

Sagnik Mukherjee · Post by **Sagnik Mukherjee** » Tue Dec 04, 2012 3:01 am

the translate function replaces a sequence of characters in a string with another set of characters. Right? I want to do that in modify stage. If I use transformer, then I can think of use Convert function.But as its not available in Modify stage so I want another function which can do the same thing.

SettValleyConsulting · Tue Dec 04, 2012 4:02 am

The Modify Stage is basically a wrapper round the Modify Operator (See the Orchestrate documentation or The Datastage Advanced Parallel Developers Guide under Operators). You're limited to the conversion functions built into this operator and the type of string translation you want is not one of them.

I think your options are to write a BuildOp, a parallel routine or use a Transformer. I'd want a compelling reason not to go for the latter.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 04, 2012 1:26 pm

The equivalent Transformer function is Ereplace() (for version 9.1) or pxEreplace (earlier versions). This functionality is not available in Modify stage.