06-20-2014 02:51 PM
how can i create a temporary table (stored in a data-warehouse that i am accessing using oracle and proc sql)
here is the schematic of my problem
connect to oracle
with tableA as (select * from databaseA-in-datawarehouse);
select * from databaseB-in-datawarehouse
On certain condition
disconnect from oracle
Thank you !
06-20-2014 02:59 PM
connect to oracle as cORA (connect string from library);
create table want as select * from cORA(
with tableA as (schemaA.tableA)
from schemaB.tableb tableB
on tableA ..... = tableB....
disconnect from cORA;