MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2014

AW: AS400 DB to XML



fixed

The following SQL Command will generate an XML for a complete table/physical
file

Select XMLGROUP(Column1, Column2, .... ColumnN)
From YourSchema/YourTable;

The result can be written to the IFS by either using unix_type APIs or with
embedded SQL using file reference variables:
For more information read the following article:
Using RPG to exploit IBM DB2 XML support
http://www.ibm.com/developerworks/ibmi/library/i-using-rpg/index.html

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Debbie Panco
Gesendet: Monday, 11.8 2014 15:11
An: midrange-l@xxxxxxxxxxxx
Betreff: AS400 DB to XML


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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.







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