libname x teradata user=&userid password=&passwd server=myTeradataServer connection=global;
/* Create a volatile table */
option debug=dbms_timers
sastrace=',,,d'
sastraceloc=saslog no$stsuffix;
proc sql;
connect to teradata(user=&userid password=&passwd server=myTeradataServer
connection=global bulkload=yes);
execute
(CREATE VOLATILE TABLE temp1 (var1 varchar(15)) ON COMMIT PRESERVE ROWS ) by
teradata; execute ( COMMIT WORK ) by teradata; INSERT INTO x.temp1
SELECT * FROM mysasdataset.var1;
quit;
/* Connect to the volatile table through the global connect.*/
rsubmit;
option debug=dbms_timers
sastrace=',,,d'
sastraceloc=saslog no$stsuffix;
proc sql;
connect to teradata (user=&userid password=&passwd server=myTeradataServer
connection=global);
select * from connection to teradata
( select b.* from a, b
where xxxxxx);
quit;
/* Volatile table is automatically dropped */
libname x clear ;
... View more
