DSXchange

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

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?