Character substitution 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
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Character substitution using MODIFY stage.

Post by rkashyap »

We are using RCP to extract data from table and write to a sequential file. Double-quote is present in some of the data column, which needs to be escaped (i.e. replaced with two double-quotes).

If transformer stage is used (with RCP) for replacing double-quotes, then column position in output file is rearranged! Is it possible to implement ereplace in Modify stage?

On a related note, about a decade ago :-) Ray had shared examples of Modify stage constructs at http://home.iprimus.com.au/raywurlod/Da ... ctions.pdf. Unfortunately, this link is stale now. Can someone please share copy of this document.
Post Reply