Page 1 of 1
Equivalent of Translate fn which can be used on Modify Stage
Posted: Tue Dec 04, 2012 2:51 am
by Sagnik Mukherjee
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.
Posted: Tue Dec 04, 2012 2:53 am
by ray.wurlod
What does the Translate() function do? It's not a function that's built into DataStage.
Posted: Tue Dec 04, 2012 3:01 am
by Sagnik Mukherjee
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.
Posted: Tue Dec 04, 2012 4:02 am
by SettValleyConsulting
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.
Posted: Tue Dec 04, 2012 1:26 pm
by ray.wurlod
The equivalent Transformer function is Ereplace() (for version 9.1) or pxEreplace (earlier versions). This functionality is not available in Modify stage.