外部表的导出数据~~~~~~超级神器

db=gdb
mkdir /home/informix/czw/50w/${tab}
dbaccess -e -m ${db} <<! >./log/${tab}_imp.log 2>&1
drop table if exists ext_${tab};
create external table ext_${tab} sameas ${tab}
using
(datafiles("DISK:/home/informix/czw/50w/${tab}/${tab}%r(1..5).tbl"),
format "delimited",
DELIMITER '|',
express,
rejectfile "/tmp/${db}/${tab}.err",
maxerrors 10
);
set pdqpriority 100;
set environment IFX_BATCHEDREAD_TABLE '1';            
insert into ext_${tab} select * from ${tab};
drop table ext_${tab};
!