DB2 - JOINing a TEMPORARY table

DStageNewbie · Post by **DStageNewbie** » Mon Feb 08, 2010 8:22 am

I want to build a temp table and then use that temp table to JOIN with another DB2 table. Can this be done? I have seen other posts where its mentioned that it can be done in a UNIX script. This would not help me, since I don't know UNIX. I have built the temp table, but I think it is going away before I can JOIN it. From my db2 stage that creates the temp table, would I draw my link to a db2 stage having the table I want to JOIN to?

chulett · Post by **chulett** » Mon Feb 08, 2010 8:28 am

No, because by then your temp table would be gone. You would need to create and popuplate it 'before sql' and then join to it right then. Does this really need to be a true temp table? Perhaps you could persist the table and then drop it after job if all goes well.

DStageNewbie · Post by **DStageNewbie** » Tue Feb 09, 2010 10:01 am

the data used to populate the temp table is on another platform/server so building the temp table in the BEFORE tab would not work, right?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 09, 2010 3:21 pm

Probably wrong. At least not for that reason. The before SQL is executed on the same connection as the main part of the stage.