Retrieving XML documents from an XML collection is similar to composing documents from the collection.
To retrieve XML documents, use the stored procedure, dxxRetrieveXML(). See dxxRetrieveXML() for syntax and examples.
DAD file consideration: When you decompose XML documents into an XML collection, you can lose the order of multiple-occurring elements and attribute values, unless you specify the order in the DAD file. To preserve this order, you should use the RDB_node mapping scheme. This mapping scheme allows you to specify an orderBy attribute for the table containing the root element in its RDB_node.