MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2014

Re: AS400 DB to XML



fixed

For very simple XML you can do something like:

select '<data><id>' || id || '</id><name>' || name ||'</name> ... etc
from ...

If you xml is more complex you will have to read the manual. DB2/400 for
i has a great support for XML.
_________________________________________________________________________
On 08/11/2014 09:37 AM, Bryan Dietz wrote:
No mention of whether you are looking for native IBM i solution, but I
have used "TransferToXML.exe here:
ftp://public.dhe.ibm.com/services/us/igsc/cs2/ApiSamples/

It includes the VB source, good learning tool.

Bryan



Debbie Panco said the following on Mon, 8/11/2014 9:10 AM:

Hi, I am trying to find a way to convert an AS400 database file to an
XML file. I know that this
is not a difficult thing to do. My issue is that I simply lack the
knowledge. Is there a simple tool
in Web Sphere Development Studio Client that does this? Or does
anyone know of a utility/tool
outside of it that will do the same?

Your assistance would be greatly appreciated.


Debbie Panco
Senior Systems Analyst / Project Leader
United Consumer Financial Services
865 Bassett Road
Westlake, Ohio 44142
dpanco@xxxxxxxx<mailto:dpanco@xxxxxxxx>
440-835-6674

[cid:image001.png@01CFB544.22D8F080]


________________________________
CONFIDENTIALITY NOTICE: This message, including any attachments, is
for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.


-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact