MQSeries.net :: View topic

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » BLOB to XML

BLOB to XML

« View previous topic :: View next topic »

Author

Message

brokendrum

Posted: Mon Jul 14, 2003 7:16 am Post subject: BLOB to XML

Apprentice

Joined: 14 Jan 2003
Posts: 34

The following code produces a valid xml message:

Code:

SET OutputRoot.XML = CAST(SUBSTRING(InputRoot."BLOB"."BLOB" FROM 142) AS CHAR CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding);

But if I try to trace ${root} I get the following:

Quote:

(
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2003-07-14 14:28:00.740'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'CC.REFORMAT.INPUT.IMSWIFT'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'c3e2d840c2e3c2f24040404040404040b9946e3bb53b8822'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = 'STANDARD_GIS '
(0x3000000)ReplyToQMgr = 'BTB2 '
(0x3000000)UserIdentifier = 'u447440 '
(0x3000000)AccountingToken = X'0532303035380000000000000000000000000000000000000000000000000006'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 6
(0x3000000)PutApplName = 'pqedit '
(0x3000000)PutDate = DATE '2003-07-14'
(0x3000000)PutTime = GMTTIME '14:28:00.740'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000010)XML = (
(0x2000000) = '<?xml version="1.0"?><TMESSAGE><TMHEADER><TMVERSION>version</TMVERSION><TMAPPLID>ZYEGGB20 </TMAPPLID><TMAUTHID>ZYEGGB20 </TMAUTHID><TMACCTNO> </TMACCTNO><TMODIRTY>MT520 </TMODIRTY><TMODIRFT>ZYEGGB</TMODIRFT><TMCDIRTY>MT540</TMCDIRTY><TMCDIRFT> </TMCDIRFT><TMTRANTY> </TMTRANTY><TMCUSTKT> </TMCUSTKT><TMDIRINT> TM </TMDIRINT><TMPROCIM> 2001-</TMPROCIM><TMDUPKEY>10-05-16.14.26.47683</TMDUPKEY><TMPRIMID>30000000</TMPRIMID><TMPRIMRI>00 </TMPRIMRI><TMPRBLID> </TMPRBLID><TMPRBLQT> </TMPRBLQT><TMIDENTI>ABC123</TMIDENTI><TMKEYFLD> </TMKEYFLD><TMRECTTS> </TMRECTTS><TMIMSEQN> </TMIMSEQN><TMSTATUS> </TMSTATUS><TMDESTIN> </TMDESTIN><TMDESTMT> </TMDESTMT><TMIMMGFT> </TMIMMGFT><TMIMTRID> </TMIMTRID><TMIMRIID> </TMIMRIID><TMIMTRTY> </TMIMTRTY><TMBLIMRI> </TMBLIMRI><TMBLKSEQ> </TMBLKSEQ><TMBLKQTY> </TMBLKQTY></TMHEADER><TMDIRECTIVE>message body</TMDIRECTIVE></TMESSAGE>'
)
)

Why is my message not being parsed as XML?

jefflowrey

Posted: Mon Jul 14, 2003 8:13 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Because you have not instructed the message flow to parse the data.

Use either an RCD node to go from BLOB to XML, or use the Create Field with Parse command.

jfluitsm

Posted: Tue Jul 15, 2003 10:46 am Post subject:

Disciple

Joined: 24 Feb 2002
Posts: 160
Location: The Netherlands

In this case you should use th ecreate field with parse command bacause of your substring.
_________________
Jan Fluitsma

IBM Certified Solution Designer WebSphere MQ V6
IBM Certified Solution Developer WebSphere Message Broker V6

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » BLOB to XML

Jump to:

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

Protected by Anti-Spam ACP