DSXchange

Hi -

The job ran successfully but when I try to view the XML data on the target (Seq stage) I'm not getting the actual XML records instead getting the above data.

I did that. its works!! Thank you... But I'm getting new issue. The XML records are getting written to the sequencial file. Seeing the below texts while viewing the data from seq stage. Do you have any solution for this? <<<CC_LER>>>WebSphereMQConnector<<<CC_LER>>>5.3<<<CC_LER>>>ccwsmq<<<CC_LER>>><<...

Hi - I'm getting the below error messge while reading XML transactions from a queue. I have set datatype as longvarchar and length as 999999999. Can anyone please let me know what could be the possible root cause for this issue? Fatal Error: Virtual data set.; output of "MQ_Connector_ReadText&q...

Thanks so much for your help..

Hi..One more question...

What is advantage of MQ connector stage over MQ stage?

Thank you for your response...

Can anyone please let me know the difference between the Websphere MQ stage vs Websphere MQ connecor stage. Which stage has better advantages over other?

Thank you for the help.

Hi -

I need to develop a MQ job to read a decoded images from the XML file that present on the queue. Can any one please let me know if this can be done using MQ connector stage?

Thanks.

Hi, I have a requirement where I always need to listen to the MQ queue and write the message to the sequencial file as soon as it's arrive in the queue. I set the Message quantity option to -1 in order to make my job always in running state. When the message arrives in the queue, I see in designer t...

Hi,

I'm using MQ connector stage to read the message from MQ. Is it possible for Datastage job to listen to the MQ and trigger as soon as the messages arrived in that queue.

Thanks for your help.

Hi, I have a requirement where I need to unzip the input file. I used the command "unzip" in Execute Command activity. eg: unzip /da/st/test.zip I need all files in the zip to be unzipped in the same directory.. that means in the /da/st/ directory Can anyone please help me to achieve this?...

Hi, I'm getting XML parser error when I'm trying to read the XML file. It looks like there is a problem with the question mark (?) in the below attachment data. If I remove it, the job run successfully. Can someone please help identify the root cause of the issue? Data in issue : by chiropractor, la...

Hi, I have requirement where I need to extract the multiple records which are stored in DB2 SP CUSRSOR. Attached the part of SP. Could someone help how to handle CURSOR in Datastage (STP stage) DECLARE P_CURSOR CURSOR WITH RETURN FOR SELECT WA4.KEY_DATE, WA4.KEY_TIME, WA4.KEY_MILSEC, WA4.RECORDCD, W...

How do you read the file? Are you using CFF stage??

Hi,

In the help documentation, I see that cursor output is available only for DB2 & SQL server.

Thanks