Re: XML -- WEB400

Joel,

Thanks! The code will work excellent for me if I am pushed into using RPG. 
I would prefer .NET, but I don't get much acceptance if code isn't written 
in RPG on green screen. That would be the only reason to not use .NET. I 
agree, .NET would be the ideal solution because if the dataset writes it I 
know it will be able to read it.

Thanks for your help. By the way, iHOC looks like a very cool application.

    Dave Reiher
    System Analyst
    Prairie Farms Dairy - Corporate
    dreiher@xxxxxxxxxxxxxxxx



Joel Cochran <joelcochran@xxxxxxxxx> 
Sent by: web400-bounces@xxxxxxxxxxxx
11/10/2005 10:16 AM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
cc

Subject
Re: [WEB400] XML






Dave,

But does it need to be done in RPG? Is there a reason it can't be .NET? 
The
only reason I ask is that you already have the tools in place (except for
maybe the driver). There is no built-in mechanism for this on the 400. 
Also,
what will the schema of your XML be? If you want to later import this into 
a
handheld or other .NET program, it will need to be in the MS DataSet XML
standard.

<WARNING: blatant self-promotion>
Does this even need to be a program, or is it simply a task you have to do
once in a while? I have a new .NET Ad Hoc SQL tool out that would let you
execute your SQL and then save the results as MS DataSet XML (among other
things). If your IFS is mapped, you can save it directly to your 400. 
Check
it out at:
http://www.ihocquery.com
</self-promotion>

If you want/need to do it in RPG, here is a sample program on my website
that demonstrates writing XML to the IFS:
http://www.rpgnext.com/codesamples/BPRSLTXML.RPG

It even includes some indenting for readability. It just reads from an
array, but you could obviously alter it to read an SQL cursor instead. You
should be able to use most of the subprocedures as they are. The key one 
to
change would be "WriteData()".

HTH,
Joel


On 11/10/05, Dave Reiher/prairiefarms <DReiher@xxxxxxxxxxxxxxxx> wrote:
>
> What I am looking to do is run a SQL statement and spit out some XML to
> the IFS, if this is possible and doesn't take a ton of code to 
accomplish.
>
> Dave Reiher
> System Analyst
> Prairie Farms Dairy - Corporate
> dreiher@xxxxxxxxxxxxxxxx
>
>
>
> Dave Reiher/prairiefarms <DReiher@xxxxxxxxxxxxxxxx>
> Sent by: web400-bounces@xxxxxxxxxxxx
> 11/10/2005 09:31 AM
> Please respond to
> Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
>
>
> To
> web400@xxxxxxxxxxxx
> cc
>
> 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.
>
>
> --
> 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.
>
>