DataMigrator can create a new XML document with name/value pairs.
Note: In order to create an XML document, a Server Administrator must first configure an adapter for XML.
The Target Properties window is available by right-clicking a target object and selecting Properties.
The Target Options of the Target Properties pane for XML Targets contains the following fields/options:
Is the target type.
Is the target adapter.
Is the directory where the synonym is located.
Is the name of the XML document described by the synonym. DataMigrator will also create an XML Schema Definition with the same name as the data file and an extension of .xsd.
Is set to Insert/Update for XML documents. Note that no updates are currently performed.
Is the name of the top level element.
Is the name of the row level element.
Is the name of the column level element.
The following example uses the same table ibisamp/dminv as a source with all the actual columns and then creates a new XML target called dminvx. The element names are entered as shown:
Records - Inventory
Record -Item
Column -Detail
The first threee rows of the resulting XML document would would look like the following example when viewed in a browser:
| WebFOCUS |