【DM8】dmfldr数据导入或导出

在达梦bin目录下的dmfldr，用作数据导入/导出

格式

./dmfldr 用户名/密码 control=‘控制文件路径’ skip=1 mode=‘out/in’

举例1

将/opt/prod.dat的数据导入PROD表中

$ cat /opt/prod.dat

ProdID,ProdName,Code,ReOrder,Cost,Price,PriSrc,SecSrc,ObsoletedDate
1001,DaMeng Database,server,25,45.45,14.32,Redwood Shores,Reston,
1002,DaMeng Database,server,15,55.78,50.10,Redwood Shores,Reston,
1003,DaMeng Database,server,7,67.14,54.40,Redwood Shores,Reston,2001-02-14,
1004,DaMeng Application Server,server,25,92.87,89.13,Redwood Shores,Reston,
1005,DaMeng Internet Application Server,server,15,10.95,9.95,Redwood Shores,Reston,
1006,DaMeng JDeveloper,tools,5,78.78,81.15,Redwood Shores,Reston,
1007,DaMeng Developer,tools,10,32.32,30.22,Redwood Shores,Reston,
1008,DaMeng Reports,tools,3,45.21,40.18,Redwood Shores,Reston,
1009,DaMeng Discoverer,tools,7,12.47,10.69,Redwood Shores,Reston,
1010,DaMeng Collaborations Suite,server,25,97.32,90.12,Redwood Shores,Reston,
1011,DaMeng Real Application Clusters,server,30,7.21,6.15,Redwood Shores,Reston,
1012,DaMeng Financial Applications,apps,8,1.99,0.87,Redwood Shores,Reston,
1013,DaMeng Human Resource Applications,apps,9,92.87,89.14,Redwood Shores,Reston,
1014,DaMeng Business Intelligence,apps,11,104.21,72.34,Redwood Shores,Reston,
1015,DaMeng Maintenance Management,apps,14,12.31,8.14,Redwood Shores,Reston,
1016,DaMeng Manufacturing,apps,3,34.56,34.55,Redwood Shores,Reston,
1017,DaMeng Order Management,apps,7,56.67,56.72,Redwood Shores,Reston,
1018,DaMeng Procurement,apps,16,67.78,60.01,Redwood Shores,Reston,
1019,DaMeng Marketing and Sales,apps,9,78.89,75.97,Redwood Shores,Reston,
1020,DaMeng Project Management,apps,10,12.23,11.79,Redwood Shores,Reston,
1021,DaMeng Inventory Optimization,apps,2,23.34,12.14,Redwood Shores,Reston,
1022,DaMeng Supply Chain Management,apps,1,34.45,31.63,Redwood Shores,Reston,
1023,DaMeng Forms,tools,19,45.56,41.75,Redwood Shores,Reston,
1024,DaMeng Depot Repair,apps,2,56.67,49.34,Redwood Shores,Reston,
1025,DaMeng Tutor,apps,1,67.78,61.17,Redwood Shores,Reston,
1026,DaMeng Store,apps,9,78.89,75.00,Redwood Shores,Reston,
1027,DaMeng Outsourcing,services,3,89.90,85.90,Redwood Shores,Reston,
1028,DaMeng Consulting,services,35,12.23,12.14,Redwood Shores,Reston,
1029,DaMeng University,services,50,23.34,21.23,Redwood Shores,Reston,
1030,DaMeng Support,services,32,18.74,17.55,Colorado Springs,Reston,
1000,DaMeng Database 7.3,server,1,35.12,28.73,Redwood Shores,Reston,2014-02-14,

写控制文件

[root@study ~]# cd /opt
[root@study opt]# vim prod.ctl
LOAD DATA
INFILE '/opt/prod.dat'
INTO TABLE DMTEST.PROD
FIELDS ','

[root@study opt]# chown dmdba:dinstall prod.ctl prod.dat
[root@study opt]# su - dmdba
上一次登录：一 4月  8 14:25:35 CST 2024从 192.168.6.173pts/2 上
[dmdba@study ~]$ cd /dm8/bin
[dmdba@study bin]$ ./dmfldr DMTEST/DMTEST123 control=\'/opt/prod.ctl\' skip=1 mode=\'in\'

举例2
创建表 导出表

create TABLE TEST.dtoutput(c1 int,c2 clob,c3 clob);
INSERT INTO TEST.dtoutput values(1,0xab1211032de,'this is a dmfldr test');
INSERT INTO TEST.dtoutput VALUES(3,0XAB1211032DE,'REWRWRWCVDHGH');
COMMIT;
SELECT * FROM test.DTOUTPUT;

[dmdba@study opt]$ cat  dtfldr.ctl
LOAD DATA
INFILE '/opt/test.txt'
INTO TABLE test.dtoutput
FIELDS '|'
(C1,C2,C3)      

[dmdba@study bin]$ ./dmfldr DMTEST/DMTEST123 control=\'/opt/dtfldr.ctl\' mode=\'out\'