Multi-table XML documents

Previous Next

A multi-table XML document is allowed to contain data from multiple tables.

This document format is produced by calls to XML.MultiExportTables (except for the usoft-xml processing instruction at the top), and is re-importable by calling XML.Import.

Syntax

<? usoft-xml-processing-instruction ?>
<root-element>
  table-section
  table-section
  ...
</root-element>
 
root-element  ::=  { MultiExport | MultiImport }

The format begins with a required usoft-xml-processing-instruction. The required root element name is either "MultiExport" or "MultiImport". The root element may contain any number of table sections.

Example

<?usoft-xml version="1.0" action="multi-tables-import"?>
<MultiExport>
  <Accredited_Persons>
      <PERSON ID="177" FAMILY_NAME="Haynes" FIRST_NAME="Deborah"/>
      <PERSON ID="112" FAMILY_NAME="Smith" FIRST_NAME="John"/>
  </Accredited_Persons>
  <Employees>
      <EMPLOYEE ID="50" FAMILY_NAME="Mbouna" DEPT="Sales"/>
      <EMPLOYEE ID="112" FAMILY_NAME="Patel" DEPT="Sales"/>
  </Employees>
</MultiExport>

 

See also

Table sections

Single-table XML documents

usoft-xml processing instruction

DML instruction tags