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.