Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

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?
Michael Gautier at 2007-11-11 23:29:47 >
# 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 >