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

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

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
"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


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
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at

This thread ...


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