Is anyone aware of a tool which can convert from SQL to an XPath query? Thanks.
This is a data-warehousing project. We like the idea of storing the data in XML because it's a common data format and lends itself to a search optimization strategy built on DB2. We have found a nice front-end tool for visualization and data mining that generates SQL queries. And it looks as if we can convert an XML-based database to SQL one using tools like XMLSpy. So, the last link in the puzzle is to convert from SQL query to an XPath query - hence the question.
Anther option to simply create the data warehouse using RDB, which we may have do if we can't find this tool. Another option is to create a front end which generates XPath queries (we are assuming relatively unsophisticated users). But it would be nice and would save a lot of time if we could use one that's already there.