Libraries can be defined that automatically create temp tables for any data written there. We can even write to those libraries using EG tasks, like Query Builder. However, the QB task doesn't create a link to the table in the process flow, and you can't use the table as an input to a follow-up QB task. I think we have about 400 EG users now, and many, perhaps most, never write code. The programmers can submit something like this, and it works well within a session across step and program boundaries: libname NZ_Temp
netezza
server = &NZServer
database = &NZDatabase
schema = &NZSchema
authdomain = &NZAuthdomain
bulkunload = yes
dbmstemp = yes
connection = global
;
data NZ_Temp.Test_Table;
set SASHelp.Cars;
run;
proc sql;
select * from NZ_Temp.Test_Table;
quit; I suspect there's nothing SAS could do to make it work like I had hoped. I've also checked the documentation for other tools that we use to query Netezza, and I've found nothing.
... View more