Re: Writing XML from RPGLE -- RPG400-L

Hi, Vern.

I checked out a sample of it and it looks good like it would work, and
makes sense.

But will it do JSON, or <insert new data format here>?

That's the beauty of something like CGIDEV2 or our eRPG SDK. It's not
limited to just one format like XML. It's a very high level template
system that you can really do anything you want.

I'd love to work with you to put together examples of an application where
you (or someone else) use XMLi and I use the eRPG SDK.

Maybe someone else (or I could as well) provide a CGIDEV2 example. Just so
we can show users practical comparisons.

I may even be able to provide a practical example if that's what we need.
I've done quite a few of these. More of them these days are JSON compared
to XML though, but they could go either way.

Brad
www.bvstools.com

On Thu, Aug 21, 2014 at 11:22 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

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.

--
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.