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
As an Amazon Associate we earn from qualifying purchases.
	
 
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.