Re: Writing XML from a nested DS

Hi all



The real problem is not the technology layer since every DB can be
converted into XML or any other format.



The real problem is in the bilateral agreements where you have convert
proprietary data from one system to another – just think about shoe-sizes
where you need BL to convert between European and US sizes - nobody wants
to walk around in a US size 45 ;-)



This is where SQL generated XML ‘goes offline’ since it will require
intermediate in house files that reflects the send data.



This is however not an SQL/XML problem, it has been there since the first
EDI formats (EDIfact/X12) was developed – mapping of data isn’t as simple
as it seems!

On Tue, Nov 18, 2014 at 3:28 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Like Jon, I've looked at the SQL support for XML, including the extensive
documentation that's out there - Nick Lawrence has a considerable amount of
stuff out there, as I list here - I bet you've already looke, Michael!

http://www.ibm.com/developerworks/ibmi/library/i-using-rpg/

There is a list of additional resources near the bottom. And the last
entry in comments by Nick have a link to a major white paper on this topic
- here is the URL -

http://tinyurl.com/qduxo7m

There's a link there to the actual PDF.

Writing this is going to involve host variables with deep nesting
(qualified names) - it's not clear to me that this can all be done in one
statement, and there has not been array processing in SQL, anyhow - I
forget, has it been added recently?

Writing this with CGIDEV2 or PowerEXT or XMLi would be simple - nested
loops would be easily done in the latter 2, since they work at the node
level, not necessarily the template level. So your code would more closely
match the structure of the XML.

Now a question - what feeds the data structures you have? If it is file
data, just go directly from that, skip the structures. Just a thought!!

I'm just asking things - I'd probably go with CGIDEV2, as that's what I'm
using now and can do all I need pretty easily. But there are alternatives -
I'm just not sure the XPath stuff can handle things - I believe that would
be needed.

HTH
Vern


On 11/17/2014 7:15 PM, Jon Paris wrote:

I’d love to see the answer if you can find it Michael. I’ve found the
syntax of the SQL/XML stuff too arcane for my limited brain.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Nov 17, 2014, at 3:57 PM, Koester, Michael <mkoester@xxxxxxxxxxxxx>
wrote:

I am stretching my SQL capabilities in an attempt to write XML that

reflects a data structure, but it's clear I don't really know what I'm
doing.
Working in i OS 7.1 with TR7, most PTFs up-to-date (but no promises
there).

All the examples (articles, archives, Knowledge Center, etc.) I've come
across just deal with mapping from files, so I'm having difficulty with the
data structure aspect. I am trying to create the XML for a data structure
that has some nested arrays, but otherwise not too involved. Something on
the order of:
d AccountData ds qualified
d Notify n
d EmailTo 50a
d BillPhones likeds(PhoneDetail) dim(32)
d nbr_Phones 3u 0 inz
d BillPDFs likeds(PDFnames)

d PhoneDetail ds qualified
d Phone 10 0 inz
d PriorPayments likeds(payments) dim(16)
d nbr_Payments 3u 0 inz

d Payments ds qualified
d Amount 8 2 inz
d PaidDate 10a

d PDFnames ds
d PDFcount 3u 0 inz
d PDFid 23a dim(25)

Tools that create XML (with basic examples) are interesting, but I've
yet to see any examples of how to write XML that has nested arrays I need.
I may reconsider CGIDEV2 or XMLi, over my current efforts in SQL/XML if
someone can help me past this hurdle.

My end result is a payload for a web service response to a business
partner.

Many thanks,
Michael Koester
--
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: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
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: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.