string Decode using Modify Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rameshrr3
Premium Member
Premium Member
Posts: 609
Joined: Mon May 10, 2004 3:32 am
Location: BRENTWOOD, TN

string Decode using Modify Stage

Post by rameshrr3 »

Im just curios to knwo if there is any 'lookup*' specification in Modify stage that allows a developer to do a string to string decode .

I 've used some lookup specifications that allow you to translate Integers to Strings and vice versa , but is it possible to translate one string value to another ?.

ie if the decode array looks like this
{ 'R'='AUD'; 'X'='SUB' ; 'I'='CAS'; 'Z'='CNC' }

Is there any lookup spec i can use with Modify stage ?
Did i miss something in the documentation :roll: if I concluded that it doesnt exist ?

Also - I don't know if this is possible at all , but can a developer create a new Modify stage specification ?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No, there's only integer to string and string to integer.

You can create new specifications; you can't create new functions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply