Have you ever studied a ZUGFeRD XML definition?
Not ZUGFeRD, but SEPA and other complex XML-Definitions
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"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)
"Learning is experience … everything else is only information!" (Albert Einstein)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of myibmi via RPG400-L
Sent: Friday, 4 April 2025 10:47
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: myibmi <myibmi@xxxxxxxxxxx>
Subject: AW: XML-Into with %HANDLER
Birgitta,
Have you ever studied a ZUGFeRD XML definition? Too complex! And then think of those, who will have to maintain.
-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] Im Auftrag von Birgitta Hauser
Gesendet: Freitag, 4. April 2025 10:37
An: 'RPG programming on IBM i'
Betreff: RE: XML-Into with %HANDLER
SQL? No chance!
Why SQL can handle XML-Documents up to 2 GB.
Have you already tried it?
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization – Education – Consulting on IBM i Database and Software Architect IBM Champion since 2020
"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) "Learning is experience … everything else is only information!" (Albert Einstein)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of myibmi--- via RPG400-L
Sent: Friday, 4 April 2025 07:08
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: myibmi@xxxxxxxxxxx
Subject: AW:XML-Into with %HANDLER
Jon,
Take a XML file of eBilling ducuments like ZUGFeRD, factur-x, eOrder, ubl
formats and you know, what a huge document is. I made several apps to
handle this with one XML-INTO statement, including a lot of nested knots.
SQL? No chance!
-------- Ursprüngliche Nachricht --------
Von: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
Datum: Do., 3. Apr. 2025, 23:01
An: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxxxxxxxx>
Betreff: Re: XML-Into with %HANDLER
No - in fact you cannot do that. Given that you have 16mb available at
the level the %Handler is attached to it would have to be a massive
document to have a nested level that big - bigger than I've ever seen
for sure.
Jon Paris
Jon.Paris@xxxxxxxxxxxxxx
> On Apr 3, 2025, at 1:55 PM, Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:
>
> I'm looking all over for an answer to this but I'm a noob on this.
>
> If I have an XML that has more than 1 level nested, do I define a
%HANDLER
> procedure for each element?
>
> Jon's example processes this XML with one %Handler
>
> <Customers>
> <Company>Phones R Us</Company>
> <Company>Suchadeal Bank</Company>
> </Customers>
>
> Do I need a separate handler for each nest in this example XML? What
Data
> structure would I pass?
>
> <customers>
> <customer>
> <CustID>1001</CustID>
> <CustName>John Smith</CustName>
> <CustStatus>Active</CustStatus>
> </customer>
> <customer>
> <CustID>1002</CustID>
> <CustName>Jane Doe</CustName>
> <CustStatus>Inactive</CustStatus>
> </customer>
> </customers>
> --
> 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@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
>
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
midrange.com
