RE: XML

It would be fairly easy to write a tool in Java that would sit as a web
service on the iSeries to facilitate this for all future needs.  Basically
all you would need to do is develop a request xml document that would pass
in the name of the library and table and then create an xml result set for
the information returned to the Java program and then route it to standard
out.  You would probably want other input information like selection
criteria and that would also be pretty easy to add.  Note that by this point
you are getting close to emulating a stored procedure and it may just be
better to go that route. 

Note that adding XML as a db communication layer for a blackbox application
is asking for some real overhead issues. How do I know? I was involved on a
project using .NET as the front end, Biztalk as the broker and the iSeries
providing the data. Each layer communicated via xml web services.  With an
architecture like that the failure points go through the roof along with the
number of people needing to be involved to find/debug a problem.  Well, now
I am ranting. . . :-)

HTH,
Aaron Bartell

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Dave Reiher/prairiefarms
Sent: Thursday, November 10, 2005 9:31 AM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] XML

I have done much more development in Microsoft's .NET than using RPG. When I
did .NET development I wrote an application allowing users to seamlessly
take certain tables with them on their laptops our handhelds in the form of
XML. With .NET it was almost too easy to do this. I basically used a SQL
statement to fill a dataset and the dataset object has a writeXML function
which would spit out the XML for me. Once disconnected the dataset had a
function to read the xml back in.

Is there anything remotely similar that I could use on the 400??

    Dave Reiher
    System Analyst
    Prairie Farms Dairy - Corporate
    dreiher@xxxxxxxxxxxxxxxx
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To post a
message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.