DSXchange

Which XML stage, XML output stage or XML 8.5 Stage? If its XML output stage, disable Write to a File Option and then try running it. and later try with a Dataset instead of MQ. If the issue is with XML creation, even the error should occur while writing to Dataset as well

Close Director log. and later close all clients. Change Link names/Stage names in the job so that it will ask to save it.
Then compile it and try this. Try a throw and catch. Because even i faced the same and this helped me.

If you are getting the character in file. You can even use trim command in unix and delete it. Sed, Awk commands will help if you need to replace it.

Thanks Prasoon. This will solve my query.

This Env variable will help

I have strings
MumbaiBangaloreChennai,
NaviMumbaiBangaloreChennai,
MumbaiPuneBangaloreKolkataChennai,
PuneBangaloreKolkataChennai,

I need to replace Kolkata with Calcutta if it exists in the string. How it can be achieved? This is in Datastage 8.1

Thanks all. Will try and update you

To connect Oracle Database using Oracle Enterprise Stage, what are the pre-requisities? I am using 8.1 Version. Please help me

Instead of returning the value as -1, try getting as a different value. Like If Count matches, it should return EQUAL. Else NOTEQUAL. Try this

The Director will show you atleast one fatal error which initiated the abort. Try it

Is there any solution to achieve sending several messages clubbed as a single message using DTS as target?

I am getting five individual messages using a MQ connector, doing transformations and clubs it as a single xml and sending it to queue through DTS(MQ connector). DTS will delete the messages from work queue only once the transformations are complete and it deletes the messages based on the WMQ.MSGID...