IBM Books

XML Extender Administration and Programming


Deleting XML documents

Use the SQL DELETE statement to delete an XML document row from an XML column. You can specify WHERE clauses to refine which documents are to be deleted.

Example: The following statements delete all documents that have a value for <ExtendedPrice> greater than 2500.00.

DELETE from sales_tab
       WHERE invoice_num in
          (SELECT invoice_num from part_side_tab
           WHERE price > 2500.00)


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