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

5(j). Map Sequence Rule - <map-seq> (only for Oracle)

Connect XML-2-DB supports the use of sequences for Oracle databases. The next value of a specified sequence can be inserted into a database column. The next value of a sequence can also be passed in as a parameter to a procedure. This is done using the map-seq and the sequence-reference-information rule. The format of map-seq rule is as follows

     <!ELEMENT map-seq              EMPTY>
     <!ATTLIST map-seq
          element-name      CDATA #REQUIRED
          seq-reference     CDATA #REQUIRED
          table-reference   CDATA #IMPLIED
          proc-reference    CDATA #IMPLIED
          column-name       CDATA #IMPLIED
          param-name        CDATA #IMPLIED>

Suppose that a sequence SALES_ID_SEQ exists in the database and this sequence has to be used to generate a value for the SALE_ID column of the SALES table. The mapping file should have the following rules defined:

     <table-reference-information table-reference="Sales" table-name="SALES"/>

     <sequence-reference-information seq-reference="SalesIdSeq" seq-name="SALES_ID_SEQ"/>
Copyright Skyhawk Systems. All Rights Reserved.
Send comments and questions to
mapIdentityRule.htmTable of ContentsinsertionMapRule.htm