cat Prod.dat 查看文件内容，知晓需要建表的字段，
根据字段建分区表:
create table "DMTEST"."PROD"
(
ProdID INT NOT NULL,
ProdName VARCHAR(100),
Code VARCHAR(50),
ReOrder INTEGER,
Cost NUMBER(9,2),
Price NUMBER(9,2),
PriSrc VARCHAR(50),
SecSrc VARCHAR(50),
ObsoletedDate DATE
)
PARTITION BY RANGE ("PRODID")
(
PARTITION "P1" VALUES LESS THAN (1010) STORAGE(ON "DMTE01"),
PARTITION P2 VALUES LESS THAN(1020) STORAGE(ON "DMTE02"),
PARTITION P3 VALUES LESS THAN(1030) STORAGE(ON "DMTE03"),
PARTITION P4 VALUES LESS THAN(MAXVALUE) STORAGE(ON "DMTE04")
);

编写控制文件
vi prod.cal
LOAD DATA
INFILE '/opt/prod.dat'
INTO TABLE DMTEST.PROD
FIELDS ','

运行装载命令:
./dmfldr DMTEST/DMTEST123 control='/dm/dmfiles/prod.ctl' skip=1

验证数据
SELECT * FROM "DMTEST"."PROD"