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.
Equivalent of Translate fn which can be used on Modify Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Wed Jul 25, 2012 5:29 am
- Location: Mumbai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 14
- Joined: Wed Jul 25, 2012 5:29 am
- Location: Mumbai
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.
Sagnik
-
- Premium Member
- Posts: 72
- Joined: Thu Sep 04, 2003 5:01 am
- Location: UK & Europe
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.
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.
Phil Clarke
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: