Exporting Data to XML |
DBMaker supports the export of data from a table to an XML file. Columns may be stored as individual elements, or as attributes of the table element. When an XML file is created, an associated DTD file is created. The DTD contains information necessary for defining the elements and attributes of the XML file. The structure of both the DTD and XML file will vary depending on whether the columns are stored as attributes or elements.
Consider how the following settings affect the XML file produced by the Export to XML wizard.
Column as Element: If columns are represented as elements in the resultant files, then schema information will be retained as element attributes (data type, column name, length, etc.) in the DTD. Columns are child elements, and the table is represented as the parent element. If the XML file is later imported back into the database, then the table's structure will be exactly replicated. File objects are referenced as entities in the DTD file if Column as Element is chosen.
Column as Attribute: Columns are represented as attributes of the table element in the DTD. There is no record of the table's schema. An element in the XML file represents each record.
Export file link name for FILE type data: The original full path will reference system and user file objects if this option is selected. If this option is not selected, file type data will be treated as Long Varbinary.
Translate all tag names to uppercase: All tag names are converted to uppercase characters.
Build temp file to store LONGVARCHAR and LONGVARBINARY data type column constant: If this option is chosen, BLOB data will be stored in a temporary directory under the directory the XML file resides in. If this option is not selected, BLOB data is stored directly in the XML file.
XML file cannot include DTD file reference: if this option is selected, no DTD is created. No information about the elements will be preserved in the DTD if this option is selected.
Related topic: