Load data
characterset UTF8
truncate into table aa fields terminated by |@_@|
TRAILING NULLCOLS
(
id,
name,
phone,
sex,
ege
)
文件加载 ods sh脚本
export DataDate = TZ=aaa16 data +%Y%m%d
export DataDate = 20160404
echo $DataDate
export CtlFilePath =/home/ama/BOB/ctl/
export DBConnnection =credit/credit@10.11.111.123.1521/credit
export DataFilePath =/home/ama/BOB/ODS/
export LogFilePath =/home/ama/BOB/Log/
------------xx_table--------------
export DataFileName = "DBConnnection" control ="
DataFileName" dir =true log="$LogFilePath"\xx_table.log errors =100000 rows =10000000
exit
网友评论