Is there a tool on the iSeries that can convert a database file into XML? If there's no native iSeries software,...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
Related Q&A from Jim Mason
Java to Excel with the AS400 may be attractive, but if you have complex VBA macros in Excel, the JDBCODBC bridge will not work well for you. A better...continue reading
There are a couple of options for accessing AS/400 data, from the old way using Client Access ODBC drivers, to Java, to a new application from Groovy.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.