GLOBAL TEMPORARY TABLES

edrenckh · Post by **edrenckh** » Thu Jul 01, 2004 6:20 pm

Has anyone used them in a DS job and passed them to the next event in the same job?

I can create them, load them, but in my next process they are gone. Any parameters/tricks, etc to get them to stay?

I am trying to use them to store imtermediate results and join a 'real' table with my intermediate results set in the temp table (instead of a hash file, which I cannot join with....)

ray.wurlod · Post by **ray.wurlod** » Thu Jul 01, 2004 8:43 pm

No, temporary tables follow the rules for temporary tables; they are dropped when the user's session that created them ends.
Subsequent DataStage jobs are separate sessions.

edrenckh · Post by **edrenckh** » Tue Jul 06, 2004 2:27 pm

This is one DS job, same step or process. I can't load the table and use it right away. DS must close the thread or ?? so that the table goes away (like it should), but I want to use it.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 06, 2004 4:29 pm

Then don't use a temporary table.

Use a "real" table, and drop it once all jobs that need to deal with it have finished.

Of course, you need different authorization to create "real" tables, which will probably require negotiation skills!