將載入器資料映射至資料庫綱目

載入器文件類型定義 (DTD) 會直接映射至 WebSphere Commerce 資料庫綱目。 每個表格都是一項元素,每個直欄都是一個屬性。

範例: 將載入器 DTD 映射至資料庫綱目 

CATENTRY 表格中的 DDL 陳述式 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"
>

相關概念

相關作業

相關參照

IBM copyright