为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8
【操作系统】:linux
【CPU】:
【问题描述】*:dmfldr命令导入txt文件,txt文件中字段分隔符为0X03,字段中含有双引号时导入报错
我手头的版本测试了下是没有问题的
[dmdba@dm ~]$ dmfldr USERID=TEST/TEST123123@localhost:5237 CONTROL=\'/home/dmdba/fldrtest.ctl\'
dmfldr V8
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:UTF-8
Data file counts: 1
/home/dmdba/fldrtest.txt
Error file :fldr.bad
Dest table :TEST.FLDRTEST
Column Name Packed data type End
ID CHARACTER 0X03
NAME CHARACTER 0X03
WULIZHI CHARACTER 0X03
row buffer number is: 2
task thread number is: 2
12 rows committed
Dest table :TEST.FLDRTEST
load success.
12 rows loaded success.
0 rows not loaded due to data error.
0 rows not loaded due to data format error.
Skip logic record counts: 0
Read logic record counts: 12
Refuse logic record counts: 0
9.917(ms) time used.
[dmdba@dm ~]$ disql /@localhost:5237 as sysdba
Server[localhost:5237]:mode is normal, state is open
login used time : 2.239(ms)
disql V8
SQL> SELECT * FROM TEST.FLDRTEST;
LINEID ID NAME WULIZHI
---------- ----------- --------------- -----------
1 1 lvbu 100
2 2 zhaoyun 97
3 3 dianwei 95
4 4 "wusheng"guanyu 93
5 5 machao 91
6 6 zhangfei 90
7 7 huangzhong 89
8 8 xuchu 87
9 9 sunce 86
10 10 taishici 85
11 11 xiahoudun 83
LINEID ID NAME WULIZHI
---------- ----------- ---------- -----------
12 12 xiahouyuan 81
12 rows got
used time: 3.541(ms). Execute id is 92400.
SQL>
可以提供下具体的报错信息、文件中的行列分隔符及双引号的情况吗