Posted: Mon Jun 18, 2007 4:14 am Post subject: Exceptions in Handling BLOB messages.....
Newbie
Joined: 14 Jun 2007 Posts: 9
I am putting an Input message "Input Message" into the input queue and trying to extract it from the BLOB domain.I am trying to make a XML output message out of that as below:
SET var = CAST(InputRoot.BLOB."BLOB" AS CHAR CCSID 500);
SET OutputRoot.XML."NAME" = var;
But the O/P message is printed as below:
<NAME>X'496e707574204d657373616765'</NAME>
Tell me the correct CCSID i should use for WINDOWS???
Why the parsers is not able to identify the format?
Last but not least you are putting an XML formatted text into an xml element. The broker works as designed.
If you want your BLOB to be recognized as XML you cannot just move it there.
You must PARSE it there.
Check out the CREATE PARSE command...
Enjoy
And if you want to keep it as readable CDATA you may have to convert the BLOB to CHAR and back to BLOB.(CCSID conversion from input to CHAR to output)... _________________ MQ & Broker admin
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