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
XML File Special Character Issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Code: Select all
Ereplace(inlink.column, "<", "<", -1, 0)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.