|
|
|
Forum Newbie
Group: Forum Members
Last Login: 2/28/2009 12:13:46 AM
Posts: 3,
Visits: 2
|
|
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.
Preeti
|
|
|
|