change string function

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
ambasta
Participant
Posts: 93
Joined: Thu Jan 19, 2006 10:29 pm
Location: Bangalore

Post by ambasta »

You can use convert function...It should do for your requirement
ambasta
RAJEEV KATTA
Participant
Posts: 103
Joined: Wed Jul 06, 2005 12:29 am

Post by RAJEEV KATTA »

Convert is only a character replacement not the substring replacement.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Were you to bother with a Search you would find that an equivalent parallel function has been posted. (You also need to be aware that Change() function and Ereplace() function are essentially identical.) Search this forum for Ereplace.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
RAJEEV KATTA
Participant
Posts: 103
Joined: Wed Jul 06, 2005 12:29 am

Post by RAJEEV KATTA »

Hi Ray,I know the difference between change and ereplace function.I have tried in search for equivalent parallel function of change() but I could not find it,I saw some other workarounds like writing to sequential files in server and then using it but I couldnot find the equivalent function of change() in parallel job.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Change() is a subset of Ereplace(). Search, therefore, for a parallel equivalent of Ereplace(). Its author is DSGuru2B.
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