Problem solve Get help with specific problems with your technologies, process and projects.

Convert a database file into XML

Is there a tool on the iSeries that can convert a database file into XML? If there's no native iSeries software,...

do you know of any third-party vendors that would have such a tool?

I'm sure their are multiple vendors. We've even built our own simple mapping tool. Good choices are the IBM WDSC (WebSphere Development Studio Client for iSeries) XML tools. Most customers can get this tool at no charge. Included are two XML tools that can convert DB2 data to XML:

1. IF you BUY IBM's DB2 Extender software for iSeries (expensive), you can use two simple wizards to move DB2 data to and from XML documents:

A. The XML to RDB mapping wizard to store XML data in DB2.
B. The XML SQL Query wizard to extract DB2 data to XML.

2. IF you want a simple, no charge, portable solution for any database and don't mind coding a little Java, use the SQLtoXML and XMLtoSQL classes. I prefer these.


Check out these Best Web Links on Web development.

Ask the Experts yourself: Our Web development gurus are waiting to answer your questions.

Ask your Web development & WebSphere questions -- or help out your peers by answering them--in our .fMFNafNPDOX.2@.ee84637!viewtype=&skip=&expand=>WebSphere & Web Development Forum.

This was last published in August 2003

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.