RE: DB2XML was -> RE: Arrays of Structures as a parameter in V5R1

["Bartell, Aaron L. (TC)" <ALBartell@xxxxxxxxxxxxxx>]

>FWIW, all of the open-source stuff I've seen is (way) over my head. 
I will admit that some stuff can be quite confusing, especially when you
start dealing with some of IBM's API's, but I used to think the same way
until I actually tried to produce something open source.  Then you see all
of the motions others have gone through and you understand why things are
done certain ways.  

If you want to see some cool open source code take a look at Scott Klements
HTTP API tool and pay attention to the different levels of API's and how at
each level up they get easier to call.  http://klement.dstorm.net/httpapi/

>One question:  Is the XML output going to be limited to 32K? 

The example on the site implies that, but no, I would be foolish to assume
that I could fit all XML result sets in 32767.  There will be a whole set of
API's to get the data in different ways including writing it to a file in
the IFS.  For example:

resultXMLFile = DB2Xml_getFile('/myfolder/myfile.xml': '199.143.221.784':
'User': 'Password': SQLStatement);

CGI_outFromFile(resultXMLFile);  - this is writing to standard out.

or

parser = DOMParse_init(IFS_FILE: resultXMLFile);  

Aaron Bartell



-----Original Message-----
From: G Armour [mailto:garmour400r@xxxxxxxxx]
Sent: Wednesday, August 27, 2003 11:39 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: DB2XML was -> RE: Arrays of Structures as a parameter in
V5R1


--- "Bartell, Aaron L. (TC)" <ALBartell@xxxxxxxxxxxxxx> wrote:
> LOL!  Yeah, it took me about 3 hours to come up with a good name.  You
> wouldn't believe how many names are already taken.  It was a Saturday and
I
> was supposed to be mowing my lawn but instead I was inside programming and
> all I could think of was my neighbor yelling at me "Mow Your Lawn!!"  I
> realized there could be no better name for my site:-)

That was along the lines of what I was imagining.  <g>

> >Is this an open-source project?
> Yeah, but I am finding that doesn't mean a whole lot.  Of the other two
open
> source projects I have out there (RPGMail and RPG XML Parser) I have
pretty
> much gotten zero help from the outside world.  It would be nice if I could
> get some help, <snip>

FWIW, all of the open-source stuff I've seen is (way) over my head.  I
suspect that
might be true for most AS/400 programmers.  Additionally, when it comes to
XML, I
believe most AS/400 shops aren't "thinking outside of the box".  So, XML's
utility
may not be readily apparent to most of the community.  If you look at
another
AS/400-based open source project, Linux5250, that seems to have quite a bit
of
participation.  I looked at that one, too, awhile back, but I was limited to
testing
what they offered.

> If you have specific requirements for a tool like DB2XML please email them
> to DB2XML@xxxxxxxxxxxxxxx and I will work them in as best I can.  As of
> right now my requirements list is based on what I think should be in it so
> it might be kinda narrow minded:-)
> 
> Does anybody else see a need for this in their company?  One obvious
> advantage is that you can get at any remote or local database via XML.  It
> could save you from writing a ton of web services to output file
> information.

When I saw the example, I thought of the remote clients that we support and
how most
of them do not have DBU or a similar file utility.  So, I see alot of
potential
there.  I've only been here a few weeks now, still getting my feet wet, but
I know
one of my colleagues has been working on some of the bleeding edge stuff <g>
like
CGI in RPG, so I threw your web site at him ("Huh? Mow your lawn?" "Trust
me")  I
didn't have a lot of time to discuss the potential applications with him
(that will
come later), but he read through the whole db2xml page.

One question:  Is the XML output going to be limited to 32K?  (I.e.:
   D xml            S          32767A    )               

GA

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
_______________________________________________
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.