The XML Export Method

Previous Next

See Also

The XML export method generates XML output based on a SELECT statement. The structure of the XML output from this method is described in "XML Representation of Application Data".

This XML export method can for example be used in a corrective constraint, to fill or update a database column with the result of the XML export.




SELECT    [<value> <param>[, <value> <param> ...]]


       [,<value> <param>[, <value> <param> ...]]

FROM <table>

[ORDER BY] <order by list>



INVOKE XML.Export WITH SELECT 'yes' useioformats , * FROM t2_


The SELECT statement must comply with the following conditions:

· Value/Parameter pairs and expressions can appear in any order within the SELECT statement.


· The FROM clause contains only one table or logical view.


· For each parameter value, the parameter name must be specified.


· Within one XML export, parameters have constant values.


· The order of the columns in the SELECT list determines the order of the attributes in the XML output.


· The optional ORDER BY clause determines the order of the records in the XML output.


The possible values for <expression> are:

<column>, OLD(<column>), *, OLD(*)


All parameters are optional, and the parameter names and values (<param> and <value> in the syntax description above) are not case-sensitive. See the examples below for more information.


Allowed Values




Specifies a header line in the XML output with a DOCTYPE declaration containing the DTD Name as reference. See "Document Type Definition (DTD) Specification" for more information.


No, Yes

Specifies whether column values in the resulting XML output get the IO format of the corresponding domain or not.

If not they are written as they are retrieved from the database.


Insert, Delete, Update

Specifies a sub element that will be generated for each resulting row element. This way you can generate XML output with specifications for import actions.


No, Yes

Specifies whether tab characters, spaces, newline characters and carriage returns/line feeds are converted to &#x9; &#x20; &#xA; and &#xD respectively. When the XML document is imported using XML Import, the converted values are switched back into tab characters, spaces, newline characters and CR/LFs.


No, Yes

Specifies whether the default Rules Engine encoding is to be returned in XML processing instructions. Otherwise no encoding processing instruction is added to the returned XML document.


USFile alias, Output file name

Specifies whether the output is to be written directly to a file. It is possible to use a file which has previously been opened using the USFile.Open method. To do this, the alias used in the USFile.Open method must be specified, preceded by 'USFile.' If no USFile alias is specified, the XML will be written directly to the file specified. If the file exists, it will be overwritten. To prevent this, use the 'Append' parameter. If specified, the method will return the file name.


No, Yes

This parameter is used with the "WriteOutputTo" parameter. You can use it to specifiy whether the file is to be overwritten, or appended to.



Related Topics

Example: Simple XML Export

Example: XML Export With DTD Name And IO Formats

Example: XML Export For Update

Example: XML Export in Combination with USFile