Re: Generating DOM or SAX XML using XML4PR400 -- RPG400-L

You also might want to look at Net.Data.  It's a scripting language
similar to PHP, generally used for interactive web development, but
you can call the Net.Data program and have it write its output to a
file in the IFS.  Check out

http://dtwdude.com/forum/view.php?SID=20011212135514860904&NRL=3&KW=ADDENVVAR

Mike E.


On Tue, 2 Nov 2004 12:39:02 -0000, Beeson, Terry
<terry.beeson@xxxxxxxxxxxxxxxxx> wrote:
> Aaron
> 
> Thanks very much for your help.  I'm playing around with CGIDEV and must say 
> it is fantastic.
> 
> Thanks very much for the kick-start.
> 
> Regards,
> 
> 
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Bartell, Aaron L.
> (TC)
> Sent: 29 October 2004 17:43
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Generating DOM or SAX XML using XML4PR400
> 
> Basically you will have code that looks like the following:
> 
> /myifsfolder/cgidev2template.xml  :
> 
> /$Header_begin
> <Order id="/%orderid%/">
> 
> /$Detail
> <Item id="/%itemid%/" price="/%itemprice%/ />
> 
> /$Header_end
> </Order>
> 
> <!-- RPG Program  -->
> 
> chain ordNum OrdHdrPF;
> 
> updHTMLVar('orderid': OHINV);
> wrtSection('Header_begin');
> 
> chain OHINV OrdDetPF;
> dow not %eof;
>   updHTMLVar('itemid': ODITMID);
>   updHTMLVar('itemprice': ODPRICE);
>   wrtSection('Detail');
>   reade ordNum OrdDetPF;
> enddo
> 
> wrtToStmF('/myifsfolder/mycompletedxmlfile.xml');
> 
> ...// now you have a file in the IFS that contains your XML file.  Now
> you can do with it whatever you need. Read it. Send it to a URL. etc
> 
> >Can CGIDVE2 help me produce XML from database files?
> Not auto-majically.  Look at the above example.
> 
> >I've had a look at the CGIDEV tool and can't find any reference to XML,
> just HMTL.
> They developed it with the assumption of how it might be used.  Just
> understand that you can use it for any "templating" you may need to do -
> HTML, XML, emails, documents, etc.
> 
> >Aaron - I thought I had a solution based on your DOMPARSE Example2
> program, but I have seen on several posts etc that this won't be
> supported much longer.  Is XMLSAX another option?
> 
> XMLSAX is the way to go.  It is much faster and more stable than
> DOMParse.
> 
> >Aaron - Did you mean "Get URI" from bvstools?
> Nope, check this link out: http://bvstools.com/erpgsdk/
> 
> HTH,
> Aaron Bartell
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> Sent: Friday, October 29, 2004 9:36 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Generating DOM or SAX XML using XML4PR400
> 
> Hi
> 
> Aaron and Martin - Thanks for your replies.
> 
> I've loaded CGIDEV2 and got it working.  It looks brilliant!
> I'm working through the documentation and am having difficulty getting
> to grips with how CGIDEV can help me with my XML problem.
> 
> Our objective is to build an XML string from data stored in multiple
> Physical Files, and send it to our Supplier via FalconMQ and MSMQ
> (Message queuing software).  My goal right now is to generate the XML.
> 
> Can CGIDVE2 help me produce XML from database files?  I've had a look at
> the CGIDEV tool and can't find any reference to XML, just HMTL.
> 
> Aaron - I thought I had a solution based on your DOMPARSE Example2
> program, but I have seen on several posts etc that this won't be
> supported much longer.  Is XMLSAX another option?
> 
> Aaron - Did you mean "Get URI" from bvstools?  Also thanks for the tip
> on schema validation.
> 
> Thanks for your help :)
> 
> Regards,
> Terry
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Bartell, Aaron L.
> (TC)
> Sent: 28 October 2004 14:04
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Generating DOM or SAX XML using XML4PR400
> 
> Hi Mr Beeson,
> 
> Like Martin said I wouldn't recommend using xml4pr400 to generate your
> XML.  I would instead use a templating technology like CGIDEV2
> (http://www-922.ibm.com/servers/eserver/iseries/easy400) or Brad Stones
> eRPG SDK (http://bvstools.com).  That takes all of the XML out of your
> RPG programs to create a nice separation for ease of maintenance.  I
> must note that it would still be good for you, as you are in development
> and testing, to validate your XML against your schema using a third
> party tool (Check out WDSc's facilities) to make sure your trading
> partner is getting an agreed upon document.
> 
> Aaron Bartell
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> Sent: Thursday, October 28, 2004 7:06 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Generating DOM or SAX XML using XML4PR400
> 
> >Hi All
> >I need to generate an XML string to pass to our Supplier using
> XML4PR400.
> I'm kind of new to XML and have only parsed incoming XML using XML4PR400
> >and DOM.
> 
> hi terry,
> i'd suggest that you don't use xml4pr400.
> just use plain rpg to write your data to the ifs for such small tasks.
> you could use scott klements ifs procedures (also contained in aarons
> xml
> savefile) for this.
> 
> Otherwise look at aarons example2.
> 
> regards
>  Martin
> 
> --
> This is the RPG programming on the AS400 / 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 AS400 / 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 AS400 / 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 AS400 / 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 AS400 / 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.
> 
>