RE: Reverse xml-into

I was very busy the last few days, that's why I did not jump in.
Also as I understood it, he looked for a solution to convert a data
structure into XML.

With SQL we cannot read a data structure, but it is easy to generate the XML
document directly from the database and write it into the IFS.
The SQL statement will be a little tricky, because we have to convert the
data out of the relational database into a hierarchical form.
But when splitting the request into multiple Common Table Expressions
building the information from the lowest level and joining them in the next
CTE to the next level until the XML document is completed, your SQL
statement still stays readable. ... and it is not more difficult than
splitting a program into sub-procedures.

Writing the result of the SELECT statement to the IFS with field reference
variables is very easy (4 Statements)


Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon Paris
Sent: Dienstag, 10. September 2019 19:20
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Reverse xml-into

I figured Birgitta would have jumped in and suggested that by now ...

On Sep 10, 2019, at 10:48 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>

wrote:

+1

And you didn't mention SQL!!!

:-DO:-)

Cheers
Vern

On 9/10/2019 8:38 AM, Jon Paris wrote:

What it creates Vern is aa web service which can deliver its payload as

XML.

A bit of a cack-handed way to do and XML-FROM operation!

In addition to the XML generation options you mentioned there's also

powerExt and XMLi that provide capabilities.

On Sep 9, 2019, at 9:27 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>

wrote:

Booth - does IWS creATE an XML file? As opposed to reading one?

I think there are a couple options for creating XML in RPG -

- CGIDEV2
- SQL's XML functions

Regards
Vern

On 9/9/2019 5:13 PM, Booth Martin wrote:

I am still at the novice level with the IWS Wizard but it does xml

easily, reliably, and well.

On 9/9/2019 3:54 PM, Raul Jager wrote:

I have crated a DS for a fairly complex XML document, and xml-into

does a wonderful job moving the data into the fields.

Now I will like to put data into the DS and create a XML document, the

reverse of the xml-into op ccode. Is there a way to do this?

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color

-- -- Verificado por Anti-Virus Corporativo Symantec --

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post
a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
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: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
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: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
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:
https://amazon.midrange.com