Posted: Sun May 02, 2010 12:17 am Post subject: How to convert XML message to a String?
Novice
Joined: 28 Aug 2009 Posts: 20 Location: India
Hi, i have the following requirement - An incoming XML message should be inserted to database as a single column i.e, message_body. My flow has MQnput , Compute and a Error handling sub flow. Domain of MQInput used is XMLNSC. I need to store the incoming XML message in a single CHAR variable so as to insert into DB. How do i do it?
Posted: Sun May 02, 2010 6:44 am Post subject: Re:How to convert XML message to a String?
Jedi Council
Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land.
raghu1984 wrote:
Convert the InputRoot.XML to BLOB using ASBITSTREAM function and then convert the BLOB to CHAR using CAST function.
Should it not be:-
Convert the InputRoot.XMLNSC to BLOB using ASBITSTREAM function and then convert the BLOB to CHAR using CAST function _________________ WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
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