14 May 2012
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.
Brian Butler Teradata Consultant 415 318 9700
15 May 2012
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
27 Aug 2012
take a look at the link below:
You must sign in to leave a comment.
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;