Example: Constraint Processing an XML Import

See Also

Here is an example of a constraint that calls the XML import method, and processes the xml_document column in the XML_IMPORTS table. This table is also the transition table.

The column values to be imported must NOT be checked against the IO format of the corresponding domains. This is specified by the UseIOFormats parameter.

INVOKE    XML.Import

WITH

SELECT    OLD(xml_document) XmlDocument

       ,'No' UseIOFormats

FROM     XML_IMPORT_TABLE

If a record in the XML_IMPORTS table is updated or deleted, the old value for the xml_document column will be imported.