控制文件:case2.ctl.txt
load data
infile case2.dat.txt
replace into table bonus
(
ename position(1:5)
job position(7:15)
sal position(17:20)
)
数据文件:case2.dat.txt
smith cleak 3904
allen salesman 2891
ward salesman 3128
king president 2523
load data
infile case2.dat.txt
replace into table bonus
(
ename position(1:5)
job position(7:15)
sal position(17:20)
)
数据文件:case2.dat.txt
smith cleak 3904
allen salesman 2891
ward salesman 3128
king president 2523
infile case2.dat.txt
replace into table bonus
(
ename position(1:5),
job position(7:15),
sal position(17:20)
)(另,数据格式有按指定的起始列开始。)