Hi,
Something to explore.
https://www.itjungle.com/2012/08/08/fhg080812-story02/
Greets
Danny
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim L.
Bostwick
Sent: vrijdag 9 maart 2018 22:43
To: rpg400-l@xxxxxxxxxxxx
Subject: Creating XML document via SQL - Db2 for i 7.2
I am trying to create an XML document using SQL and am having a very
difficult time just using the SQL XML Programming Manual and the SQL
Reference.
I am trying to create a document that looks like this, writing out to an IFS
file.
<Request>
<Product>
<Profile>
<Data>
<field1>1</field1>
<field2>2</field2>
</Data>
<NewGroup>
<field3>1</field3>
<field4>2</field4>
</NewGroup>
</Profile>
</Product>
</Request>
I am really looking for more than a 1 liner on what the various functions do
like XMLCONCAT (and a couple examples), or how do you create parent/child
groupings like product/profile....
Trial and error is driving me crazy (er)......
TIA
Jim Bostwick
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-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
