Skyhawk Systems - Simplify data transformations
Products | Download | Buy | About Us
 
Table of Contents Connect XML-2-DB User's Guide mappingFile.htmTable of ContentstableRefInf.htm

5(a).  Root Element of Mapping File - <map-rules>

The root element of the mapping file is <map-rules>. It comprises of either database object reference information elements or mapping rule elements. A detailed description of each of the elements is provided in later sections.

  • For SQL Server, the element <map-rules> has the format:
       <!ELEMENT map-rules       (table-reference-information | 
                                  procedure-reference-information |
                                  map |
                                  map-const |
                                  map-param-const |
                                  insertion-map |
                                  map-identity |
                                  xml-propagation-rule |
                                  db-propagation-rule)+>
	
      <!ATTLIST map-rules
          root-element    CDATA #REQUIRED
          map-version     (1.0) "1.0">				  
	  
  • For Oracle, the element <map-rules> has the format:
       <!ELEMENT map-rules       (table-reference-information | 
                                  procedure-reference-information |
                                  sequence-reference-information |
                                  map |
                                  map-const |
                                  map-param-const |
                                  insertion-map |
                                  map-seq |
                                  xml-propagation-rule |
                                  db-propagation-rule)+>
	
      <!ATTLIST map-rules
          root-element    CDATA #REQUIRED
          map-version     (1.0) "1.0">
	  

The root-element attribute has to have the name of the root-element of the XML data file.

The map-version attribute refers to the version of the mapping file format. It has to have 1.0 as the value.

Only mapping files for SQL Server can have the element map-identity. Only mapping files for Oracle can have the elements sequence-reference-information and map-seq. A detailed description of these is provided in Map Identity, Sequence Reference Information, and in Map Sequence

Copyright Skyhawk Systems. All Rights Reserved.
Send comments and questions to support@skyhawksystems.com.
mappingFile.htmTable of ContentstableRefInf.htm