Hello Michael,
My end result is a payload for a web service response to a business
partner.
RPG-XML Suite by Krengeltech might be worth a look.
I've never used it, perhaps not even seen a demo (never yet having been
involved with an application on the i that required something like this),
but I've been intrigued by it over the years:
http://www.rpg-xml.com/free-proof-of-concept/
René A Valencourt, CCP, MCTS
Senior Programmer/Analyst
IS Department
CTB, Inc.
A Berkshire Hathaway Company
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Koester,
Michael
Sent: Monday, November 17, 2014 3:57 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Writing XML from a nested DS
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.
midrange.com
