InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 16:04:53 GMT20http://www.teradata.com/teradataforum/Topic14598-22-1.aspxHi,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 usingconnect to teradata (user ='user pwd = 'xxxxx' server ='SERVER' connection = 'global');I am trying something like thisproc sql;connect to teradata (user ='user pwd = 'xxxxx' server ='SERVER' connection = 'global');execute (create volatile table abc as (select distinct COLUMN1 from DATABASE1.TABLE1 UNIONselect 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 statementI am getting the error:ERROR: Teradata execute: Request aborted by TDWM. Exception criteria exceeded: CPU Time, CPU Disk Ratio.Fri, 27 Feb 2009 23:45:12 GMTpreeti1234