Teradata fastload极速导入数据

在UE编辑器中编写，F9快捷键输入DOS命令fastload %f执行

sessions 2;

.errlimit 25;

logon IP/USERID/PASSWORD;

drop table TABLENAME;

create table TABLENAME (

COL1 varchar(10)

,COL2 varchar(10)

) primary index(COL1);

drop table log1;

drop table log2;

begin loading TABLENAME errorfiles log1,log2;

.set record vartext "|"

define

COL1 (varchar(10))

,COL2 (varchar(10))

file = E:\AA\BB.TXT;

insert into TABLENAME.*;

show;

end loading;

logoff;

 

转载于:https://www.cnblogs.com/king-cobra-rko/p/11166553.html