通过SAS fastload Mysql table 到 Teradata

/*clear fastload tables*/
%let gdw_dir =( user="XXXXX" password="XXXXX" database="XXXXX" tdpid="XXXXX");
proc sql;
connect to teradata as TD &gdw_dir;
execute (drop table STG_MYSQL_lkp_verticals)
by TD;
execute (commit) by TD;
disconnect from TD;
quit;
proc sql;
connect to teradata as TD &gdw_dir;
execute (drop table append_err1)
by TD;
execute (commit) by TD;
disconnect from TD;
quit;
proc sql;
connect to teradata as TD &gdw_dir;
execute (drop table append_err2)
by TD;
execute (commit) by TD;
disconnect from TD;
quit;
proc sql;
connect to teradata as TD &gdw_dir;
execute
(
create table STG_MYSQL_lkp_verticals
(
vertical varchar(10),
category_id integer,
category_name varchar(70),
short_name varchar(70)
)primary index(vertical,category_id)
)
by TD;
execute (commit) by TD;
disconnect from TD;
quit;
/*create source data table*/
libname bu_data mysql user='XXXXX' password='XXXXX' database='XXXXX' server='XXXXX' port=XXXX;
proc sql;
create table work.lkp_verticals as
select vertical, category_id, category_name, short_name
from bu_data.lkp_verticals
;
quit;
libname TDPET teradata databASe=XXXXX user="XXXXX" pASsword="XXXXX" TDPID="XXXXX";
proc append data=work.lkp_verticals base=TDPET.STG_MYSQL_lkp_verticals
(bulkload=yes bl_log=append_err);
run;