Q

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.

==================================
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

Dig deeper on Web Development

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close