XML in an XML Column is stored in an internal format, that cannot be compared with any other format.
If you want to convert the internal XML into a readable character representation you need to convert it with XMLSERIALIZE.
If you want to store a character representation of an XML in an XML Column you need to check whether it is a wellformed XML document and convert it into the internal format with XMLPARSE.
If you only want to create and display the XML XMLSERIALIZE is not necessary (at least if you run your SQL Statement with Client Access or ACS Run an SQL Script.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
„Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael J. Raber
Sent: Freitag, 14. Juli 2017 17:28
To: midrange-l@xxxxxxxxxxxx
Subject: Jumping into XML on the AS/400 - solution
Hi Alan,
it seems that my mail was not processed, so my answer to your question on this way:
To get a XML using SQL you have to serialize. This is an example:
select xmlserialize(xmlelement(name "field1", myfield1) as char(1024)) from myfile
gives you something like this:
<field1>content1</field1>
<field1>content2</field1>
<field1>content3</field1>
--
Signatur
Mit freundlichen Grüßen / Kind regards
*Michael Raber* *|* CEO *|* *Dipl.-Ing. Michael J. Raber*
Mobil: +49 1520 8523 330 *|*mail@xxxxxxxxxx <mailto:mail@xxxxxxxxxx>*|* www.mjraber.de <
http://www.mjraber.de>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
