Page 1 of 1

GLOBAL TEMPORARY TABLES

Posted: Thu Jul 01, 2004 6:20 pm
by edrenckh
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....)

Posted: Thu Jul 01, 2004 8:43 pm
by ray.wurlod
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.

Posted: Tue Jul 06, 2004 2:27 pm
by edrenckh
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.

Posted: Tue Jul 06, 2004 4:29 pm
by ray.wurlod
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!