dm8 利用dmfldr将数文件导入到dm数据库中

--建测试表

create huge table ZLZ

(

C1 character varying(20),

C2 character varying(20)

)

把以下数据放到/home/dmdba/zlz/test.txt文件中

1 1|2015-11-06

2 2|2015-11-05

3 3|2015-11_04

--编写控制文件

[dmdba@RS1824 zlz]$ cat T_DNS.ctrl

LOAD DATA

INFILE ''/home/dmdba/zlz/test.txt''

INTO TABLE zlz

FIELDS '|'

(

C1 TERMINATED BY ' ',

C2,

C3 DATE FORMAT 'yyyy-mm-dd'

)

--执行脚本：

-- log=\'/home/dmdba/zlz/T_DNS.log\' character_code=\'GBK\' MODE='IN' 其他参数可以指定

[dmdba@RS1824 zlz]$ /home/dmdba/ljr/dmdata/dmdpc/bin/dmfldr userid=SYSDBA/SYSDBA@192.168.104.24:7644 control=\'/home/dmdba/zlz/T_DNS.ctrl\' ；

执行结果：

dmfldr V8

dmfldr:

Copyright (c) 2011, 2015, Dameng. All rights reserved.

Control file:

Loaded rows: All

Rows per commit to server: 50000

Rows to skip: 0

Errors count allowed: 100

Whether to load direct: Yes

Whether to insert identity column: No

Whether data is sorted by cluster index: No

Character sets:GBK

Data file counts: 1

/home/dmdba/zlz/test.txt

Error file :fldr.bad

Dest table :ZLZ

Column Name Packed data type End

C1 CHARACTER WHT

C2 CHARACTER |

C3 yyyy-mm-dd |

row buffer number is: 80

task thread number is: 80

3 rows committed

Dest table :ZLZ

3 Rows loaded success.

Due to data format error, 0 rows abandon.

Due to data error, 0 rows not loaded.

Skip logic record counts: 0

Read logic record counts: 3

Refuse logic record counts: 0

The total time used: 22.427(ms)

在数据库验证结果有到数据库中

达梦数据库 - 新一代大型通用关系型数据库 | 达梦云适配中心达梦数据库产品体验站，DM8在线试玩，达梦数据库全系列产品免费下载，官方权威的快速上手文档和产品手册，最活跃的达梦技术社区，面向全行业ISV厂商免费的云适配服务。https://eco.dameng.com/