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?

    Requires Free Membership to View

    Login

    Register today to access targeted resources from our editorial writers and independent industry experts including news, tips, and advice to help you do your job more efficiently and effectively. Stay informed on the hottest topics and biggest challenges faced by IT professionals working with iSeries products and services.

    By submitting your registration information to Search400.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of Search400.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

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 first published in August 2003

Back to top