DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Naren12345babu



Group memberships:
Premium Members, Heartland Usergroup

Joined: 06 Jan 2016
Posts: 67
Location: Bangalore
Points: 828

Post Posted: Fri Aug 11, 2017 12:35 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 53980
Location: Sydney, Australia
Points: 292863

Post Posted: Sun Aug 13, 2017 11:05 pm Reply with quote    Back to top    

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?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours