John
I think that is what I am looking for, the code on how to do it in ESQL,
I'm not an expert ESQL programmer.
Thanks
Francois van der Merwe
Senior IT Specialist: IBM MQSeries Certified Specialist, Solutions Expert &
Developer
IBM, Cape Town, South Africa
+27 (0)82 556 9467 / +27 (0)21 402 5597
[EMAIL PROTECTED]
John Scott
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
.CO.UK> cc:
Sent by: MQSeries Subject: Re: How to fix invalid XML
with broker
List
<[EMAIL PROTECTED]
N.AC.AT>
05/12/2003 10:40
Please respond to
MQSeries List
What you're looking to do is remove the second <?xml ... ?> instruction and
enclose the whole lot in a <Yikes> element.
Can you cast the message to a non-XML plain string and then use string
manipulation to find the end of the first <?xml ... ?> and insert a
<Yikes>,
then find and remove the next <?xml ... ?> and then append </Yikes>
Regards
John Scott
IBM Certified Specialist - MQSeries
Argos Ltd
-----Original Message-----
From: Francois Van der Merwe1 [mailto:[EMAIL PROTECTED]
Sent: 05 December 2003 08:24
To: [EMAIL PROTECTED]
Subject: How to fix invalid XML with broker
Using WBIMB V5 fixpack 2
I've got the following invalid xml flowing into the broker:
<?xml version="1.0" encoding="UTF-8"?>
<Header>
<Info1> Something </Info1>
<Info2> Something else </Info2>
</Header>
<?xml version="1.0" encoding="UTF-8"?>
<DaDetail>
<Record>
<Name>Groot Kokkedoor </Name>
<Salary> 1000</Salary>
</Record>
<Record>
<Name>Nelson </Name>
<Salary> 100</Salary>
</Record>
</DaDetail>
So, from above, the XML is invalid. I need to change it with the broker
to:
<?xml version="1.0" encoding="UTF-8"?>
<Yikes>
<Header>
<Info1> Something </Info1>
<Info2> Something else </Info2>
</Header>
<DaDetail>
<Record>
<Name>Groot Kokkedoor </Name>
<Salary> 1000</Salary>
</Record>
<Record>
<Name>Nelson </Name>
<Salary> 100</Salary>
</Record>
</DaDetail>
</Yikes>
Any ease way to do this?
Thanks
Francois van der Merwe
Senior IT Specialist: IBM MQSeries Certified Specialist, Solutions Expert &
Developer IBM, Cape Town, South Africa
+27 (0)82 556 9467 / +27 (0)21 402 5597
[EMAIL PROTECTED]
Instructions for managing your mailing list subscription are provided in
the
Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
***********************************************************************************
Click here to visit the Argos home page http://www.argos.co.uk
The information contained in this message or any of its attachments may be
privileged and confidential, and is intended exclusively for the addressee.
The views expressed may not be official policy, but the personal views of
the originator.
If you are not the addressee, any disclosure, reproduction, dissemination
or use of this communication is not authorised.
If you have received this message in error, please advise the sender by
using the reply facility in your e-mail software.
All messages sent and received by Argos Ltd are monitored for virus, high
risk file extensions, and inappropriate content. As a result users should
be aware that mail maybe accessed.
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
