XML.SQLExport compared to XML.Export

Previous Next

Contrast XML.SQLExport and XML.Export:


Single-table: The FROM clause may only contain a single table name (naming a database table, Logical View, or component table)

Simple output: The SELECT output list may only contain simple column names or the * wildcard. SQL functions and mathematical operators are not allowed.

No meta-data: the output is raw data, as opposed to (also) information about how the data was computed. No reference is made to the origin of the data: a relational database with tables and columns.


Multi-table: the FROM clause may contain any number of table names.

Full SQL syntax: SQL functions and mathematical operators are allowed in the SELECT output list.

Meta-data: the <Meta> tag contains all the details of the SELECT statement that retrieved the data.