Re: Writing XML from RPGLE

Hi Brad

I'm going to throw in a consideration when choosing a method here - and I'm coming from NOT using the SQL support - which is more of a bottom-up approach as Birgitta presented it.

We have basically 3 approaches here - 1) the recent SQL support 2) templates (CGIDEV2 and your eRPG) 3) nodes (powerEXT as presented by Henrik)

Another approach is that of XMLi - it has a choice of the node approach or a different kind of template approach - worth looking at.

OK - for putting data into XML, I think the node approach is really good. This would be the case with the examples we've seen here, where we are really dealing with all our own data.

However, I'm working on creating Excel workbooks in the latest XLSX format - there is SO much stuff that is not coming from our data, that I REALLY don't want to put all that into code. Much of it is essentially boilerplate.

Just a little history from me - I worked on an web application that had ALL the HTML being written in the RPG - that makes for really big programs, or lots of them, to do the job. When I started to rewrite it using CGIDEV2, it was SO clean and much smaller. AND it was no longer necessary to do all that stuff with strings withing 80 columns!

So having sections that include what is kind of like boilerplate has worked very well for me.

I looked briefly at XMLi, and its templates include bits that call out to other things, like SQL SELECT statements in order to get the data - a little like some NET.DATA things I looked at years ago - ignore that comment if you like!!

So a couple criteria for deciding which approach to use.

1. If your XML will only have your data in it, go with nodes (API calls to build the whole thing, as in powerEXT and XMLi).

2. If the XML structure is from an external source and has lots of stuff that is NOT your data, go with a templated approach.

3. For something in between, see what is best for you.

HTH
Vern

On 8/21/2014 9:59 AM, Bradley Stone wrote:

Brian,

As mentioned CGIDEV2 our our eRPG SDK could be used for this.

They are template based applications that are able not only to output
dynamic content to the web, but stream files in the IFS.

Normally used for dynamic HTML, they can be used to generate dynamic
"anything" (XML, JSON, JavaScript... anything!)


Brad
www.bvstools.com


On Thu, Aug 21, 2014 at 7:46 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

With CGIDEV2 it is as easy as populating and writing printer files.
SQL has all kinds of publishing functions, that can be easily used within
RPG
And embedded SQL even has a very easy way to directly write to the IFS.

So Why to reinvent the wheel and adding additional opcodes?

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!"

-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Brian
Stapleton
Gesendet: Thursday, 21.8 2014 14:32
An: RPG400-L@xxxxxxxxxxxx
Betreff: Writing XML from RPGLE

Good Morning Guru's and Masters of RPGLE


Thank you to all who replied to my earlier email about writing XML from
within RPGLE. I will go back into the digest and read up on the different
approaches.

The XML files that I will be generating are fairly nested, and are for the
purpose of transferring data to another system. (Non AS/400 - Yeah, not
happy about that myself) and I will be pulling the data from several
different files.

I was hoping that the latest release of RPGLE would have Op codes similar
to
XML-Into / XML-SAX that write XML code to the IFS, and it looks like such a
thing doesn't exist.

Thank you to all who responded for your help.




Brian Stapleton
Information Services
Carhartt, Inc
5750 Mercury Drive
Dearborn, MI 48126
Desk - 313-749-6586
Fax - 313-271-3455
BStapleton@xxxxxxxxxxxx<mailto:BStapleton@xxxxxxxxxxxx>

[Description: Description: Carhartt_emaillogo]


Confidential: This electronic message and all contents contain information
from Carhartt, Inc. and its affiliates which may be confidential or
otherwise protected from disclosure. The information is intended to be for
the addressee only. If you are not the addressee, any disclosure, copy,
distribution or use of the contents of this message is prohibited. If you
have received this electronic message in error, please notify us
immediately
at (313) 271-8460 and destroy the original message and all copies.
--
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.