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

Look for examples on the web from Birgitta Hauser. There are also out some there from Scott Forstie and other IBMers.

Personally I still find it all too much trouble - but then SQL syntax and I don't like each other much <grin>


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

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