通过SAS fastload Mysql table 到 Teradata，

通过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;