SAS/ACCESS to TERADATA

Analytics

SAS/ACCESS to TERADATA

Hi,

I want to know how can we join two tables in two different database in teradata server using PROC SQL.

Inside PROC SQL I am connecting to teradata using
connect to teradata (user ='user pwd = 'xxxxx' server ='SERVER' connection = 'global');
I am trying something like this

proc sql;
connect to teradata (user ='user pwd = 'xxxxx' server ='SERVER' connection = 'global');
execute (create volatile table abc as
(select distinct COLUMN1 from DATABASE1.TABLE1
UNION
select distinct COLUMN2 from DATABASE2.TABLE2
)
) with data on commit preserve rows)
by teradata;
execute (commit work) by teradata;
quit;
Now how do I define two different database in same server in connect to teradata statement

I am getting the error:
ERROR: Teradata execute: Request aborted by TDWM. Exception criteria exceeded: CPU Time, CPU Disk Ratio.