Hi All,
I am moving an XML content from SQL server table to a file.
In my XML content , I have (') , and Control Z characters.
datastage is not able to read these values , it writes the file with 'SUB' character.
PLease help to solve this.
thanks
Special characters in Test - How to handle in datastage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
Special characters in Test - How to handle in datastage
Thanks
Naren Babu Ch
Naren Babu Ch
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Control Z (0x1a) shouldn't be a problem on UNIX (it's the end-of-file indicator on Windows). Likewise a regular apostrophe oughtn't to be a problem. What exactly are you trying to achieve, and how are you going about it?
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.