Creating an XML file to use unique-index ID resolution

About this task

Use the unique-index resolution, which is the default behavior of the idresgen utility when:
  • There is no entry in the properties file for the table being analyzed.
  • There is no properties file.

Unique-index resolution uses any of the specified unique indexes on a table as a means of locating the identifier.

To update the contents of the database, you need to know the unique key from the primary table in the database. You can query your database to find this out. For example, a DB2 command for retrieving a unique key will look similar to the following:

db2 describe indexes for table 
schema.tablename show detail

Procedure

Partial example of unique-index resolution
Before resolution:

  <MEMBER
    MEMBER_ID="100"
    TYPE="O"
    STATE="1"
  />

<CATALOG
CATALOG_ID="@WC2001@100"
DESCRIPTION="Winter Catalog"
IDENTIFIER="WC2001"
MEMBER_ID="100"
TPCLEVEL="2"
/> 
  <CATALOGDSC
    CATALOG_ID="@WC2001@100"            
Refers back to catalog "WC2001" of member 
                                        "100" (Note: The order is
important.)
    FULLIMAGE="c:\store\img\wc.gif"
    LANGUAGE_ID="-1"
    LONGDESCRIPTION="2001 Winter Catalog"
    SHORTDESCRIPTION="2001 Winter Catalog"
    NAME="B2B direct 2001 Winter Catalog"
    THUMBNAIL="c:\store\img\wc_th.gif"
  />
After resolution:

  <MEMBER
    MEMBER_ID="100"
    TYPE="O"
    STATE="1"
  />
  <CATALOG
    CATALOG_ID="10351"                 A
utomatically generated primary key
    DESCRIPTION="Winter Catalog"
    IDENTIFIER="WC2001"
    MEMBER_ID="100"
    TPCLEVEL="2"
  />
  <CATALOGDSC
    CATALOG_ID="10351"                 
Refers to the correct catalog
    FULLIMAGE="c:\store\img\wc.gif"
    LANGUAGE_ID="-1"
    LONGDESCRIPTION="2001 Winter Catalog"
    SHORTDESCRIPTION="2001 Winter Catalog"
    NAME="B2B direct 2001 Winter Catalog"
    THUMBNAIL="c:\store\img\wc_th.gif"
  />