Hi, I have a column in a database that contains a complete XML message.
Although its obvioulsy easy enough to retrieve the data, it comes in as a text string and I need to recreate the XML message as proper XML.
I have tries pushing it through a resetmessagecontentsdescriptor node but it has no effect, I suspect that behind the scenes the XML has been returned with '&'lt and '&'gt instead of <> so the reset thinks its just text
anyway any hints will be appreciated
thanks
Paul
[ This Message was edited by: pmbsa on 2001-11-06 06:51 ]
[ This Message was edited by: pmbsa on 2001-11-06 07:10 ]
[ This Message was edited by: pmbsa on 2001-11-06 08:23 ]
Hi Eddie, after the RCD node there is no output becuase it complains about the XML (as I said the <> have been replaced)
The XML is perfect I have chacked & double checked (Using standard sql and writing out to a file which I read into and XML parser
the ESL we are using is
SET OutputDestinationList.Destination.Scratchpad.Inboundmsg.XML.Tester = THE (SELECT ITEM M.INBOUND_MESSAGE
FROM Database.db2admin.MESSAGE AS M
WHERE M.MESSAGE_IDENTIFIER
= InputBody.WfMessage.ActivityImplInvoke.ProgramInputData.TPCIMessage.TPCIID);
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