一、CSV导出通过控制文件
1.设置控制文件
cat department_g_out.ctl
options
(
character_code='UTF-8'
)
load data
infile 'dmhr_department_utf.csv'
badfile 'department_utf.bad'
into table dmhr.department
fields ','

2.创建外部表
create EXTERNAL TABLE eb_depart(
"DEPARTMENT_ID" INT,
"DEPARTMENT_NAME" VARCHAR(30),
"MANAGER_ID" INT,
"LOCATION_ID" INT)
from DATAFILE DEFAULT DIRECTORY EXT_DEPARTMENT LOCATION ('dmhr_department_utf.csv')
PARMS (fields delimited by ',',skip 1,records 0x0d0a,badfile 'department.bad',character_code 'UTF-8')

3.通过dmfldr导出外部表，添加COLNAME_HEADING带表头方式导出。
dmfldr userid=cndba/yumben123 control='dmhr_department_utf.ctl' mode='out' LOB_DIRECTORY='/dm8/backup/dts/department' COLNAME_HEADING=TRUE