Example: Mapping mass load utilities data to a database schema

The mass load utilities document type definition (DTD) maps directly to the WebSphere Commerce database schema. Each table is an element, and each column is an attribute.

Feature Pack 6 or laterThe massload utility is deprecated for WebSphere Commerce Version 7 Feature Pack 6. The Data Load utility is the recommended command-line loading utility. If you are currently using the mass load utility, you are recommended to switch to the Data Load utility to load your CSV and XML input files into your target database. If your system contains scheduled and automated processes that use massload, it is recommended that you update these processes to use the Data Load utility. Other WebSphere Commerce utilities that use the massload utility, such as the acpload utility, continue to use the massload utility in WebSphere Commerce Version 7 Feature Pack 6. If you have business reasons to continue using the massload utility, you can continue to use this utility. For more information about the Data Load utility, see Overview of the Data Load utility. You can switch to the Data Load utility by using the TableObjectMediator to load your data when no business object mediator exists for the data that you are loading. For more about the TableObjectMediator formation, see Data Load utility table-based mediator and builder.

DDL statements for the CATENTRY table DTD 

CREATE TABLE 
   "CATENTRY" (
   "CATENTRY_ID"   BIGINT       NOT NULL ,
   "MEMBER_ID"     BIGINT       NOT NULL ,
   "CATENTTYPE_ID" CHAR(16)     NOT NULL ,
   "MARKFORDELETE" INTEGER      NOT NULL ,
   "PARTNUMBER"    VARCHAR(64)  NOT NULL ,
   "MFPARTNUMBER"  VARCHAR(64)           , 
   "MFNAME"        VARCHAR(64)           ,
   "URL"           VARCHAR(254)          , 
   "FIELD1"        INTEGER               , 
   "FIELD2"        INTEGER               ,
   "FIELD3"        DECIMAL(20,5)         , 
   "FIELD4"        VARCHAR(254)          , 
   "FIELD5"        VARCHAR(254)          ,
   "LASTUPDATE"    TIMESTAMP             ,
   "OID"           VARCHAR(64)           ,
   "ONSPECIAL"     INTEGER               , 
   "ONAUCTION"     INTEGER               ,
   "BUYABLE"       INTEGER               ,
   "BASEITEM_ID"   INTEGER               ,
   "CLASSIFGRP_ID" INTEGER               ,
   "ITEMSPC_ID"    INTEGER               , 
   "STATE"         INTEGER 
);


<!ELEMENT CATENTRY EMPTY>
<!ATTLIST CATENTRY
    CATENTRY_ID      CDATA  #REQUIRED
    MEMBER_ID        CDATA  #REQUIRED
    CATENTTYPE_ID    CDATA  #REQUIRED
    MARKFORDELETE    CDATA  #REQUIRED
    PARTNUMBER       CDATA  #REQUIRED
    MFPARTNUMBER     CDATA  #IMPLIED
    MFNAME           CDATA  #IMPLIED
    URL              CDATA  #IMPLIED
    FIELD1           CDATA  #IMPLIED
    FIELD2           CDATA  #IMPLIED
    FIELD3           CDATA  #IMPLIED
    FIELD4           CDATA  #IMPLIED
    FIELD5           CDATA  #IMPLIED
    LASTUPDATE       CDATA  #IMPLIED
    OID              CDATA  #IMPLIED
    ONSPECIAL        CDATA  #IMPLIED
    ONAUCTION        CDATA  #IMPLIED
    BUYABLE          CDATA  #IMPLIED
    BASEITEM_ID      CDATA  #IMPLIED
    CLASSIFGRP_ID    CDATA  #IMPLIED
    ITEMSPC_ID       CDATA  #IMPLIED
    STATE            CDATA  "1"
>