Re: XML to DB2 and vice versa

Hi Geir,

I don't have specific experience with DB2 -> XML out, but I have done a 
few different types of XML documents going in to our database.  If I had 
started with V5R4, I think I would have just used the XML-INTO opcode for 
parsing XML.  That being said, we're not at V5R4 yet, but I've found that 
the Expat parser, ported by Scott Klement and available from 
http://www.scottklement.com/expat worked very well for my needs.  We've 
looked at some of the third party options and found them to be either too 
limited or too expensive for our particular level of XML usage.

Using Expat took a bit of work for the first program, but after that it is 
quite easy to adapt that program to other documents.  The Expat download 
comes with some great examples.  A couple of things that I might have done 
differently are to start out using iconv() instead of QDCXLATE (there are 
examples of both), and use the full XPath instead of just the current tag 
name to figure out what processing needs to be done in the callback 
routines.  This will probably make more sense when you look at the 
examples.

As far as outputting XML, the best I can do is let you know some of the 
options I would consider.  CGIDEV2 is meant for outputting HTML, but can 
be used for XML as well.  Aaron Bartell has a set of APIs which is mainly 
focussed on Web Services, but I think could work well for simply parsing 
and composing (http://rpg-xml.com/index.htm).  Also, the DB2 XML extenders 
have a nice tie-in with the WDSC XML tools.

HTH,
Adam

Geir wrote on 17/10/2006 05:33:31 AM:

Hi.

I have a need for converting incoming XML-files to DB2-files on the 
AS/400. I also want to send DB2-files in XML-format. 

Is there a 'black box' for this included in the OS/400? I'm soon 
gonna use 5.4.

I know there are some third part companies that can deliver 
something like this.

Does anyone of you have practical experience with this. My needs are
not very advanced, it is simple files in and simple files out.

Regards 

Geir

#####################################################################################
Attention:
The above message and/or attachment(s) is private and confidential and is 
intended 
only for the people for which it is addressed. If you are not named in the 
address 
fields, ignore the contents and delete all the material. Thank you. Have a nice 
day.

For more information on email virus scanning, security and content
management, please contact administrator@xxxxxxxxxxxx
#####################################################################################