dmfldr载入数据报错字符串截断

解决方法：查看数据库字符集是GB18030，导入时指定字符编码
dmfldr userid=xxxx/xxxxx:5237 control=’/db/soft/table_dm.ctl’ CHARACTER_CODE=‘gbk’

table_dm.ctl文件：
OPTIONS
(
SKIP = 1
)
load data
infile ‘/ngbss/mddms/interface/other/ess/bin/20241014_71_Staff.ECREQ’
replace into table td_table
fields ‘,’
TRAILING NULLCOLS
(
staffid ,
staffnum ,
provid ,
departid ,
staffname ,
sex ,
homeeparchcode,
postinfo ,
email ,
certtype ,
certnum ,
numid ,
birthdate ,
status ,
LIABLE_NAME ,
LIABLE_PSPT_CODE ,
LIABLE_SERIAL_NUMBER,
LIABLE_MAIL ,
STAFF_ID_STATE ,
LIABLE_HOLDER ,
SELF_STAFF_ID ,
para1 ,
para2
)