Query-sas/access to teradata

Database

Query-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.
1 REPLY
Enthusiast

Re: Query-sas/access to teradata

Hi,

Your query got aborted because it reached the assigned maximum limit of resources. There must be an exception criteria defined on CPU Time and Disk Ratio with the exception action "Abort". Plus check the stats on both the tables, recheck the indexes for less consumption of CPU..Otherwise contact your DBA group.