Loading XML from database
Does anyone know how to load an AS/400 database to XML?
[55 byte] By [
Kevhead] at [2007-11-9 15:27:21]

# 1 Re: Loading XML from database
Websphere
"Kevhead" <kevhead@megsinet.com> wrote in message
news:3dd6b6bd$1@tnews.web.dev-archive.com...
>
> Does anyone know how to load an AS/400 database to XML?
# 2 Re: Loading XML from database
What do you mean by load to XML?
If you mean retrieve data from the database and put it into XML - there are
many ways. Depends on what you have available or can get. Is your database
DB2. If so, DB2 comes with/has available extenders that allow you to retrieve
the data as XML. It would be best that you do this processing on the AS/400.
Since you didn't say ISeries, I take it that your machine is not up to date
(?). You could pull the data via a PC and use a PC base tool. That should
be down your list of choices. Hopefully, since you are using a non-PC OS
(at least one) you are using Java to do you development.
Let me know your environment/tools. BTW, Websphere might be part of the
solution. Not sure if Michael meant WAS or the Websphere platform (WAS,
MQ, WSAD, ...)
"Michael Gautier" <gautier_michael@hotmail.com> wrote:
>Websphere
>
>"Kevhead" <kevhead@megsinet.com> wrote in message
>news:3dd6b6bd$1@tnews.web.dev-archive.com...
>>
>> Does anyone know how to load an AS/400 database to XML?
>
>
Mark at 2007-11-11 23:30:53 >

# 3 Re: Loading XML from database
most databases like SQL Server, support this:
SELECT * FROM mytable FOR XML AUTO
you can look up the "FOR XML AUTO" for more details and options...
Mikey at 2007-11-11 23:31:52 >
