Administer > Transforming, loading, and extracting data > Overview of the mass load utilities > Load data using the mass load utility
Example: Mapping loading utilities data to a database schema
The loading utilities document type definition (DTD) maps directly to the WebSphere Commerce database schema. Each table is an element, and each column is an attribute.
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" >
Related concepts
Overview of the mass load utilities
Related tasks
Related reference