Example: Constraint Processing an XML Import

Previous Next

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


SELECT    OLD(xml_document) XmlDocument

       ,'No' UseIOFormats


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