Try SQL2XML if your data is not large.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: 12 August 2009 16:16
To: Java Programming on and around the iSeries / AS400
Subject: Utility to convert database file into XML
HiDoes anyone know of any utility which would convert database file into XML, for example if i have a table like below
Table1
Name 10 A
Id 5 0
place 10 A
and data is
Name Id Place
ABC 001 USA
XYZ 002 NYC
Xml file will be
<table1>
<row>
<name type="java.lang.String" length="10">ABC</name>
<id type="java.math.BigDecimal" length="5" decimal="0">001<id>
<place type="java.lang.String" length="10">XYZ</place> </row>
</table1>
I can write some thing in java, but dont want to reinvent wheel if some open source utility is out there doing the same
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/java400-l.
Consider the environment and think before you print this email.
Registered Address: Fortis House Tollgate Eastleigh Hampshire SO53 3YA Registered Number: 354568 England
Authorised and regulated by the Financial Services Authority
This e-mail together with any attachments are intended for the addressee only and may be private and confidential. If you are not the intended recipient, or the person responsible for delivering it to the intended recipient, you must not open any attachments, or copy, disclose, distribute, retain or use this e-mail, including any attachments, in any way whatsoever; please return it to us immediately using the reply facility on e-mail.
Consider the environment and think before you print this email.
midrange.com
