sas teradata fastload issue

Question

Is there a fast way to load data to teradata? I need to load 350,000 account numbers to teradata and it's been running for about 4.5 hours now.

I am just using a data step. Below is my code. Thank you

libname myid  teradata authdomain=IDWPRD server=IDWPRD database=myid mode=teradata connection=global;

proc delete data=myid.tera1;
run;

proc sql; 
create table out.REQ_1_1_05l as 
select distinct ACCOUNT_NB as ACCT_NB
FROM OUT.REQ_1_1_05;
quit;

data myid.tera1;
set OUT.REQ_1_1_05l ;
run;

Answer 1

Use the bulkload=yes option in your libname statement:

libname myid teradata bulkload=yes 
                      authdomain=IDWPRD 
                      server=IDWPRD 
                      database=myid 
                      mode=teradata 
                      connection=global;

data tera.want;
     set have;
run;

Additional performance information specific to Teradata can be found here: http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001405937.htm