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
原创
2020-07-04 15:55:08 ·
286 阅读 ·
0 评论