Special characters in Test - How to handle in datastage

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
Naren12345babu
Premium Member
Premium Member
Posts: 76
Joined: Wed Jan 06, 2016 9:40 am
Location: Bangalore

Special characters in Test - How to handle in datastage

Post by Naren12345babu »

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
Thanks
Naren Babu Ch
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply