IBM Books

XML Extender Administration and Programming

Deleting an XML document from an XML collection

You can delete an XML document that is composed from a collection. This means that if you have an XML collection that composes multiple XML documents, you can delete one of these composed documents.

To delete the document, you delete a row in the table that composes the top element_node that is specified in the DAD file. This table contains the primary key for the top-level collection table and the foreign key for the lower-level tables.

For example, the following DELETE statement specifies the value of the primary key column.

DELETE from order_tab 
   WHERE order_key=1

ORDER_KEY is the primary key in the table ORDER_TAB and is the top element_node when the XML document is composed. Deleting this row deletes one XML document that is generated during composition. Therefore, from the XML point of view, one XML document is deleted from the XML collection.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]