Re: XML representation of SQL queries?

Richard Tobin wrote
> Is there a standard way of representing SQL queries in XML?

There's a represention of SQL query *results* as XML that's been adapted
for different purposes. Java (JDBC) defines the format of a WebRowset
that's also supported by grid services and the Globus Toolkit.

Representing the SQL query source as XML would require an XML vocabulary
that can accommodate SQL as a moving target (different SQL dialects). Not
every SQL platform implements the SQL:2003 standard and platform providers
often implement extensions to the standard.

The problem is somewhat analagous to trying to develop a standard XML spec
for office documents. One standard might support Java embedding, whereas
another might support embedded OLE components.





--------------------------------------------------------------------
http://mail2web.com - Microsoft® Exchange solutions from a leading provider -
http://link.mail2web.com/Business/Exchange



_______________________________________________________________________

XML-DEV is a publicly archived, unmoderated list hosted by OASIS
to support XML implementation and development. To minimize
spam in the archives, you must subscribe before posting.

[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Or unsubscribe: xml-dev-unsubscribe@l...
subscribe: xml-dev-subscribe@l...
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php