XML.MultiExportTables

Previous Next

Exports data to the USoft multi-table format on the basis of a regular expression identifying a set of tables.

Subtype indicators are NOT exported. See also the RestrictiveSupertypeListing parameter in this help topic.

Using this method, you can create an output file with data from multiple tables. You can use XML.IMPORT to re-import this result set into a target repository where each of the tables is present.

Syntax

INVOKE XML.MultiExportTables WITH SELECT
    regular-expression
,   parameter,    value
,   ...      ,    ...

The required regular-expression identifies the set of tables from which data is exported.

The optional parameter-value pairs specify additional options. See the Parameters section in this help topic.

You can append WHERE clauses to restrict the output to records that match WHERE conditions. See the "Appended WHERE clauses" section in this help topic.

Example

This statement, executed in USoft Definer, returns an XML document describing Table, Column and Domain metadata:

INVOKE XML.MultiExportTables WITH SELECT
    '(T_TABLE|T_COLUMN|T_DOMAIN)'

collapseParameters
collapseAppended WHERE clauses
collapseSubstitution variables in appended WHERE
collapseBehaviour with subtypes

 

 

See also

XML.Export

XML.SQLExport

XML internal component

XML and the Rules Engine