DSXchange

I had been able to dump the message from the MQ into a SEQ file and then process it thru the XML input stage. The issue is, when I feed the message from MQ into the XML stage, I am not getting any output. I checked the DTD and the xpaths and it looks good. I would appreciate any new suggestions.

I am getting the whole message in one column. I created another job to move the message to the XML input stage and put the result into a SEQ file. MQ==>XMLInput==>SEQ I coded XPATH for the clientTransactionName and am not getting any output from the XML stage. It looks like the XML stage is not reco...

I am using the XML Input after the MQ. Here is how my job is:

MQ==>XML INPUT==>XFM==>XML OUTPUT (multiple)

I am trying to develop a job to read XML from MQ. What I want to do is read the message from the Q and parse the header of the XML and validate the type of transaction it is, and based on the value, pass it to an XML output stage and write each XML to a separate file. When I move the message to the ...

I am getting input XML in the format below. I need to pull the value in the tag <name> and create 1 row with 7 columns (populated by the different values in the <name> tag). Since the tag name <EObjCdProdTp> is the same for all the blocks, I am getting 7 rows and 1 column. Is there a way to do this?...

Thanks Ernie. I ran the job in version 7.5 and it works just fine. I wish someone knew the patch number.

I am still looking for help on this topic.

Ernie, Here is the XML: <?xml version="1.0"?> <!DOCTYPE TCRMService SYSTEM "tCRMResponse.dtd"> <TCRMService> <ResponseControl> <ResultCode>SUCCESS</ResultCode> <ServiceTime>50</ServiceTime> <DWLControl> <requesterLanguage>100</requesterLanguage> <requesterName>Susan 000107564</re...

The closing tab is at the end of the XML details. The last two tabs are </TxResponse>
</TCRMService>. I hope this is what you are asking about.

Ernie, The response type is at the top of the structure, but not the root. And yes, it does tell what the rest of the structure will be. Here is how it looks: <?xml version="1.0"?> <!DOCTYPE TCRMService SYSTEM "tCRMResponse.dtd"> <TCRMService> <ResponseControl> <ResultCode>SUCCES...

I am getting multiple XML responses for different data elements like (Business Units, Country codes, currency codes) from MDM-WCC in the same MQ. I need to get the message and based on <response type> field in the XML, move the message content to the element specific XML file. I thought I could use ...