602SQL Documentation Index  

Other XML Properties in 602SQL

Restrictions during XML Import

Each XML file is read once from the beginning to the end during import. Records are inserted so that if element E1 is bound to table T1, the new record R1 will be inserted into T1 when the element E1 is terminated.

If the element E2 is bound to table T2 and occurs inside element E1, the record R1 will be inserted to table T1 before record R2 will be inserted to table T2. This is done in order to abide by a possible referential integrity rule between T1 and T2.

If a value of column C from record R1 occurs in element E1 after element E2, it will also be written to record R1. The following will happen immediately afterwards:

If the data of a higher level is placed after the data of a lower level in an XML file, it will be necessary to take into consideration that the data will be written out of sequence during import and that it may be necessary to remove referential integrity rules.

In case of import to ODBC data source, the additional writing of values described above is not done at all. Therefore it is necessary to list in the XML file first the values from the parent record and only after those the values from the child records.

Known XML Issues

  1. Create DTD from DAD.
  2. Export data from a table including type information (this will make it possible to create a table and fill it with data from a single XML file).
  3. Only write URLs to the database pointing to data, instead of the actual data when exporting to an XML file (typically for images).
  4. Aggregation functions on output to XML (e.g. a sum of values over a group of elements inside an element).
  5. Recursive calls to export/import.
  6. Execute special actions for a record inserted during XML import.

List of topics: