XML SELECT Command

The CData Virtuality Server can dynamically construct complex XML documents using XML Document Object Models. A document model is generally created from a schema and is bound to the relevant SQL statements through mapping classes.

XML documents may also be created via XQuery with the XMLQuery function or with other SQL/XML functions.

Querying XML documents is similar to querying relational tables. An idiomatic SQL variant with special scalar functions controls which parts of a given document should be returned.