DSXchange

Iam having special characters(&,<,>,..) in my data extracted from the source (DB2 database). Iam using a DB2 stage for this . I want to remove this special characters and control characters if any during the extraction from the source and before the creation of the XML File. Iam using a XMLWriter for creating the XML File. Is there any provision in DataStage to control these special characters during the extraction of data from the source.

Thanks
Maharaj

You could always use the Ereplace function in a Transformer stage, or in a Routine called from a Transformer stage. For example Unfortunately, this approach requires one Ereplace per special character. But, if there aren't many of these, it ought not to be too great a burden.