Re: AS400 DB to XML

I think you should rely point out that this support (unless I am misremembering) was introduced in V7 Birgitta - the situation at V6 and earlier was not as pretty. And even this simply produces a flat structure which may or may not fit the requirements.


On 2014-08-11, at 10:03 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:

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.


--
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.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com