XML.Import

Processes the row elements of an XML document with their instructions. The behavior of the import method is determined by the processing instructions in the XML document and by the VerifyOriginalValues and UseIOFormats parameters.

The required SELECT output-list is made up of 0 or more value parameter-name pairs and 1 required (SQL) expression named by the XMLDocument alias. Possible values for the value parameter-name pairs are listed in the table below. Expression is usually a filepath pointing to a file on the file system, in which case the FROM clause is typically omitted. If expression refers to a database column, the possible values for expression are:

It is customary, but not mandatory, to list value parameter-list pairs before expression.

Parameters

This table lists all parameter-names supported in the SELECT output-lists passed to XML.Export. For each parameter-name, possible values are listed. The use of each parameter-name is optional, but if the parameter has a default value, this is the value applied if your statement does not specify otherwise.

value

parameter-name

Description

{ yes | no }

UseIOFormats

Value is a string and must be quoted, as in the example earlier in this help topic.

If you specify 'yes' for this parameter, the imported column values are checked against the IO format of the corresponding domain. Otherwise, they must use the format described in "XML Representation of Date Values".

{

\|	ChangedColumns

\|	AllColumns

\|	NoCheckOnPk }

VerifyOriginalValues

Value is a string and must be quoted, as in the example earlier in this help topic.

For row elements with an Update or Delete instruction, this parameter specifies whether the values in the XML document must be compared with those stored in the database.

See the section below for the meaning of each possible value.

{ yes | no }

XmlDeclaration

Value is a string and must be quoted, as in the example earlier in this help topic.

If you specify 'yes' for this parameter, the default Rules Engine encoding is returned as an XML processing instruction. Otherwise, no encoding processing instruction is added to the returned XML document.

VerifyOriginalValues

Setting this parameter allows optimistic locking mechanisms and prevents lost updates if different client applications change the same information concurrently.

value	Description
No (the default)	No comparison between values in the XML document and the database.
ChangedColumns	Before records are deleted, the values mentioned in the XML document are compared with the column values to be updated in the database. Before records are updated, the values mentioned in the XML document are compared with the column values to be updated.
AllColumns	Before records are deleted or updated, the values mentioned in the XML document are compared with the corresponding column values in the database.
NoCheckOnPk	In spite of there being a request for update or delete, if the record does not exist in the database, no error will be raised.