create external table dbname.ext_z21 SAMEAS dbname.z1
using (
datafiles (
“DISK:/home/informix/z1_files/1_0_Z1.txt”,
“DISK:/home/informix/z1_files/1_1_Z1.txt”,
“DISK:/home/informix/z1_files/1_2_Z1.txt”
),
format “delimited”,
DELIMITER “,”,
rejectfile “/tmp/rejectfile_1.err”,
deluxe,
maxerrors 100000
);
set pdqpriority 99;
insert into z1 select * from ext_z21;
informix数据库的外部表的形式导入数据
最新推荐文章于 2022-01-04 11:54:30 发布