Tjerk,

We have found a couple of products on IBM's Alphaworks site.  One of
them uses the "DB2 XML Extenders" mapping of XML<=>SQL.  The other
seems to create a default mapping based on SQL metadata.

Both of them are limited to Linux & Windows.  While we may use these,
our main RDB is DB2 for ISeries.  So we are still checking.

If you are curious, the links are:  
  http://www.alphaworks.ibm.com/tech/xtable
  http://www.alphaworks.ibm.com/tech/db2uriaccess

Thanks for your help,

Terry

Tjerk Wolterink <tjerk@w...> wrote in message news:<41af773a$0$69638$1b2cd167@n...>...
> Terry P wrote:
> > Tjerk,
> > Thanks for the response.  
> > In particular, I expect to be using a DB2 database with XML Extenders
> > (IBM).  I may need this on different platforms - Linux, ISeries,
> > Win2000.
> >
...
> >>>Terry
> >>
> >>What sory of database are you talking about?
> >>A ordinary relational database? Or an XML-database.
> >>Xml-databases are new and not very fast, but there is extensive research in xml-database-system.
> >>Those system support xpath and xquery as query languages.
> >>
> >>I'f you want to map xpath onto sql, then your're right: you need some
> >>rules about how xml is mapped onto the relational database.
> >>With those rules you could map xpath expression to sql expressions.
> >>
> >>I don't know wether they exists. I myself have my own mapping rules,
> >>rather simplistic rules but it does the job for me.
> 
> I've never seen an Xpath to SELECT [] FROM [] WHERE clause translation.
> And it is not easy to do that,
> because you have to have rules in how you store xml in a relational database.
> 
> I think that's also the reason there are no tools to do that.
> So can't help you there.