load SAS dataset into Teradata Volatile table

Connectivity
Enthusiast

load SAS dataset into Teradata Volatile table

I have several SAS tables that require to be copied over to Teradata platform V13.

I usually use the Fastload option and works very well, however I need to create and

load Teradata Volatile tables.  I have a pgm that works tried with 10K records and takes 8 minutes this is to long. the full table to load is 26 million. has anyone tried loading a TERADATA Volatile table without using the Insert into method

is there any other method? 

/* Set global connection for all tables. */
libname x teradata user=test pw=test server=boom connection=global;

/* Create a volatile table. */
proc sql;
connect to teradata(user=test pw=test server=boom connection=global);
execute (CREATE VOLATILE TABLE temp1 (col1 INT)
ON COMMIT PRESERVE ROWS) by teradata;
execute (COMMIT WORK) by teradata;
quit;

/* Insert 1 row into the volatile table. */
proc sql;
connect to teradata(user=test pw=test server=boom connection=global);
execute (INSERT INTO temp1 VALUES(1)) by teradata;
execute (COMMIT WORK) by teradata;
quit;

4 REPLIES

Re: load SAS dataset into Teradata Volatile table

I had a issue much like yours, SAS provided http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#45162


This fixed my performance issue.

Enthusiast

Re: load SAS dataset into Teradata Volatile table

not sure, to me it looks like you do single row insert into your volatile table

do you have a scratch place to fastload the data into TD - thats how I do it

Re: load SAS dataset into Teradata Volatile table

take a look at the link below:

http://support.sas.com/kb/21/038.html

Fan

Re: load SAS dataset into Teradata Volatile table

@v_gabreilli   Did you ever solve this problem? If yes how ?  Cn you please let me know.I too am facing a Situation where i have to insert 6 million rows into a  Teradata Volatile table using SAS but it runs forever.