Other XML Properties in 602SQL

Data Transfer Between XML Files and ODBC Data Sources

Errors in DAD design

XML Data import does not import all records

This generally occurs when only a single record is imported. If there is text information in the record, it will be chained from other imported elements.

Example:

The following DAD is incorrect.

i XML TOP
E <root> TABLE Tab
  E <record> Multi_occurrence
        Tx Tab.tx
  E </record>
E </root>

What is wrong? The rule that a table must be connected to the element whose each occurrence corresponds with one record in the table is valid in the analytic DAD. The Tab table here is connected to the root element. If there is one root element in the XML file and more occurrences of the record element, then the data from record elements will be inserted to a single new record in the Tab table when importing data.

The correct version of this DAD has the Tab tab connected to the record element:

i XML TOP
E <root>
  E <record> TABLE Tab
        Tx Tab.tx
  E </record>
E </root>

Other XML Properties in 602SQL

Data Transfer Between XML Files and ODBC Data Sources