informix数据库的外部表的形式导入数据

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;