× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: Creating XML document via SQL - Db2 for i 7.2
  • From: "Danny Rodius" <danny.rodius@xxxxxxxxx>
  • Date: Sat, 10 Mar 2018 06:41:45 +0100
  • Ironport-phdr: 9a23:AI+QFRcW7npJTyaiMOi7qIqalGMj4u6mDksu8pMizoh2WeGdxcW9YR7h7PlgxGXEQZ/co6odzbaO6Oa4ASQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9HiTahb75+Ngm6oRnMvcQKnIVuLbo8xAHUqXVSYeRWwm1oJVOXnxni48q74YBu/SdNtf8/7sBMSar1cbg2QrxeFzQmLns65Nb3uhnZTAuA/WUTX2MLmRdVGQfF7RX6XpDssivms+d2xSeXMdHqQb0yRD+t6LplSALziCcfKTE27H3XhMJ3jKJeuh2hphp/yJPQbIyaMPdye6XQds4YS2VcRMZcTyxPDJ2yb4QNEuQPM+VWoIbhqFUBqhW+GRKhBP/txz9HmnP6w7E23/onHArb3AIgBdUOsHHModn7OqkdS+a1zK/IzD7ec/1W3iry6InVchA6r/2HQLV9ftfLxkkpEQPEjk+cqZbiPzyI1+QNrnOb4vF7VeKsi28nrR9+oiS1ysg3lIbEn4QYwU3K+yV+xYY6P9y4SEhjbN6lDJtQtTyaN415QsMmXW5kojo1yroDuZKjeSgKyYkoxwTFZPyBfIiH/AjvW/qWITd9nH5qYre/iAyz8EinzO3wTNW70FFPriZdiNbMs3EM1xrJ5sibTftw+Fqq1zWX1w3L6exIPFo4mbTUJpMu2LI8iJUevETZEiPrmkj7jKmbfVg+9Oey8eToeLDmq4eZN49zlw7xLLwjmte6AeQkKggOWHWb+fik2L3j40L5RLJKg+U4nKbDtpDaI8QaqLSnDgNN04Yj7QiwDyu+3dkbgHULNkxJdR2IgoTzJV3DL/D1Ae2ij1mukDpn3/XGMafgApXJIHjDirDhfbNl5kFB0gUzy9Zf5pJOBrEbJ/L8R07xtMHDDhIiKAy0wObmCNNj2YMCQ26AGbGWPLvIsVCU/uIvP/WMZIgNtTbnM/gl6PHjgWMllVMEeamkxp4XaHGlEfR8OUqZZ3XsjckbHWgWuQo+Sb+itVuZTDQGZ2quR7luoXY/CZm6FsHGR4y3ibqO0WGwGZgRY2lHDlWFFzDsdp6YWvECb2WIOsA9ymRBUeudTNprmiuWm0fi0b1oNOPR/yweutrk0pBp5+CbtDsXvT08O4S06CbRFzk8l2UEDz4N0bp+rFdJixjJmfxim/METYQW49tMUwsgPJjTwqpxDNWkCSzbedLcAnqvRNO3SQs2QtMs2JVGN0p0HdOzyArE0yu3GJcOlK2NCYBy+K+KjCu5HNp013uTjPpptFIhWMYaaTyr
  • List-archive: <https://archive.midrange.com/rpg400-l/>
  • List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
  • List-id: "RPG programming on the IBM i \(AS/400 and iSeries\)" <rpg400-l.midrange.com>
  • List-post: <mailto:rpg400-l@midrange.com>
  • List-subscribe: <https://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
  • List-unsubscribe: <https://lists.midrange.com/mailman/options/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.