Re: Writing XML from RPGLE

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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.