Re: Creating XML document via SQL - Db2 for i 7.2

On Mar 9, 2018, at 4:42 PM, Jim L. Bostwick <jlbostwick@xxxxxxxxxxxxxxxxxx> wrote:

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