converting xml to physical file data

[svchetan]

hi,

How do i convert an xml file data into a physical file in AS/400. Im using v5r1 system. Could u please suggest me the method of moving xml data into physical file


regards,
chetan

[Fuerchau]

You will find anything under:
http://publib.boulder.ibm.com/iserie...2711720117.htm

[Sven Schneider]

if you want write your own application, use xml toolkit :

http://www-1.ibm.com/servers/eserver.../software/xml/

with java as your preferred language, you don't need xml toolkit :

- the xml parser/xsl transformer are completely free. (ASF xerces/xalan)
- to put your data into a physical file (sql table) you can also use JDBC.

[Stefan Prauss]

hi,

How do i convert an xml file data into a physical file in AS/400. Im using v5r1 system. Could u please suggest me the method of moving xml data into physical file


regards,
chetan

You could also use an EDI converter to manage this job.
The advantage in this case is, that you can fill multiple files at the same time (for example for XML formats that required a header/detail relationship such as SALES-ORDERS).

[KM]

Hi Chetan,

if you are an RPG programmer, just have a look at the following website. I'm using this freeware tool for parsing XML files and filling iSeries database files with RPG. There is included an SAX parser and a DOM parser. With little modifications this tool works properly.

http://mowyourlawn.com/index.php

best regards,
KM

[andigoering]

chetan,

if you are open for commercial applications, have a look at our tool "i4XML". It helps you with Parsing and Generating XML files.
Have a look at http://www.goering.de for details and a free download.

Best Regards

Andreas Goering