使用达梦DMFLDR进行数据加载

一、系统环境：
OS:麒麟6
数据库版本：DM7
二、操作步骤：
1、在/home/dmdba下，创建测试数据文件
[dmdba@localhost ~]$
cat >>/home/dmdba/prod.dat<<EOF
ProdID,ProdName,Code,ReOrder,Cost,Price,PriSrc,SecSrc,Obsolet edDate
1001,TestTest Database,server,25,45.45,14.32,Redwood Shores,Reston,
1002,TestTest Database,server,15,55.78,50.10,Redwood Shores,Reston,
1003,TestTest Database,server,7,67.14,54.40,Redwood Shores,Reston,2001-02-14,
1004,TestTest Application Server,server,25,92.87,89.13,Redwood Shores,Reston,
1005,TestTest Internet Application Server,server,15,10.95,9.95,Redwood Shores,Reston,
1006,TestTest JDeveloper,tools,5,78.78,81.15,Redwood Shores,Reston,
1007,TestTest Developer,tools,10,32.32,30.22,Redwood Shores,Reston,
1008,TestTest Reports,tools,3,45.21,40.18,Redwood Shores,Reston,
1009,TestTest Discoverer,tools,7,12.47,10.69,Redwood Shores,Reston,
1010,TestTest Collaborations Suite,server,25,97.32,90.12,Redwood Shores,Reston,
1011,TestTest Real Application Clusters,server,30,7.21,6.15,Redwood Shores,Reston,
1012,TestTest Financial Applications,apps,8,1.99,0.87,Redwood Shores,Reston,
1013,TestTest Human Resource Applications,apps,9,92.87,89.14,Redwood Shores,Reston,
1014,TestTest Business Intelligence,apps,11,104.21,72.34,Redwood Shores,Reston,
1015,TestTest Maintenance Management,apps,14,12.31,8.14,Redwood Shores,Reston,
1016,TestTest Manufacturing,apps,3,34.56,34.55,Redwood Shores,Reston,
1017,TestTest Order Management,apps,7,56.67,56.72,Redwood Shores,Reston,
1018,TestTest Procurement,apps,16,67.78,60.01,Redwood Shores,Reston,
1019,TestTest Marketing and Sales,apps,9,78.89,75.97,Redwood Shores,Reston,
1020,TestTest Project Management,apps,10,12.23,11.79,Redwood Shores,Reston,
1021,TestTest Inventory Optimization,apps,2,23.34,12.14,Redwood Shores,Reston,
1022,TestTest Supply Chain Management,apps,1,34.45,31.63,Redwood Shores,Reston,
1023,TestTest Forms,tools,19,45.56,41.75,Redwood Shores,Reston,
1024,TestTest Depot Repair,apps,2,56.67,49.34,Redwood Shores,Reston,
1025,TestTest Tutor,apps,1,67.78,61.17,Redwood Shores,Reston,
EOF

2. 创建控制文件

[dmdba@dm1 ~]$ cat>>/home/dmdba/prod.ctl<<EOF
LOAD DATA
INFILE ‘/home/dmdba/prod.dat’ INTO TABLE TEST
FIELDS ‘,’
EOF

3. 建表

create table test (ProdID int,ProdName varchar(40),Code varchar(30),
ReOrder int, Cost int, Price int,
PriSrc varchar(30), SecSrc varchar(30),
ObsoletedDate date)；

4. 加载数据

[dmdba@localhost bin]$./dmfldr sysdba/SYSDBA control=’/home/dmdba/prod.ctl’ skip=1

dmfldr V7.6.0.142-Build(2019.03.12-103811)ENT
dmfldr:
Copyright © 2011, 2015, Dameng. All rights reserved.
控制文件：
加载行数:全部
每次提交服务器行数:50000
跳过行数:1
允许错误数:100
是否直接加载:Yes
是否插入自增列:No
数据是否已按照聚集索引排序:No
字符集:GBK
数据文件共1个:
/home/dmdba/prod.dat
错误文件:fldr.bad
目标表:TEST
列名 包装数据类型 终止
PRODID CHARACTER ,
PRODNAME CHARACTER ,
CODE CHARACTER ,
REORDER CHARACTER ,
COST CHARACTER ,
PRICE CHARACTER ,
PRISRC CHARACTER ,
SECSRC CHARACTER ,
OBSOLETEDDATE CHARACTER ,
行缓冲区数量: 6
任务线程数量: 6
数据错误
31行记录已提交
目标表:TEST
31 行加载成功。
由于数据格式错误,1行 丢弃。
由于数据错误,0行 没有加载。
跳过的逻辑记录总数:1
读取的逻辑记录总数:32
拒绝的逻辑记录总数:0
用时:4.343(ms)

5.检查导入结果

SQL> select count(*) from test;

行号 COUNT(*)

1 31

已用时间: 0.391(毫秒). 执行号:2135.
SQL>

6、结论

没有错误，bad没有内容。
日志记录导入过程。
完成导入。