|XML Column in dashDB|
If you are using the regular dashDB service plans which are tailored to analytics, then by default all tables use columnar storage. That format provides deep compression and high performance query processing capabilities for analytic environments, but it is not suited for natively storing XML data. That is the reason why tables need to be created by explicitly stating ORAGNIZE BY ROW in the "Run SQL" dialog (see screenshot above):
CREATE TABLE myTable(id INT, doc XML) ORGANIZE BY ROW
The above statement creates the table "myTable" with two columns, the second of type XML, and in the classic row-oriented table format.
|SQL/XML Query with dashDB|
After the XML data is in, the "Run SQL" dialog can be used again to query the documents. Queries can be either in SQL (SQL/XML) or in XQuery, see the screenshots with examples.
I hope that gives you a rough idea how to utilize the pureXML feature in dashDB, even though its main focus is analytics.
|XQuery with dashDB|