Aren't GLOBAL TEMPORARY tables viewable to all connections?

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #168,462 by mmoffitt 8/10/04 1:00:27 PM Reply	Aren't GLOBAL TEMPORARY tables viewable to all connections? I thought so. This is not the case? I want the table scoped to my sp only (i.e. so that it can be fired simultaneously by n-users. Is the trick just to name the temp tables uniquely so that it doesn't matter if they all can see each other)? Thanks. bcnu, Mikem If you can read this, you are not the President.
Post #187,667 by mmoffitt 12/21/04 2:07:06 PM Reply	The answer is NO. DB2/400 doesn't scope temp tables to sp's. bcnu, Mikem Eine Leute. Eine Welt. Ein F\ufffdhrer. (Just trying to be accepted in the New America)
Post #187,668 by ChrisR 12/21/04 2:09:19 PM Reply	Are they session/user scoped?

DB2/400 or DB2/iSeries question. - (mmoffitt) - (4) - Aug. 10, 2004, 11:51:44 AM EDT

Re: DB2/400 or DB2/iSeries question. - (deSitter) - (3) - Aug. 10, 2004, 12:03:59 PM EDT

Aren't GLOBAL TEMPORARY tables viewable to all connections? - (mmoffitt) - (2) - Aug. 10, 2004, 01:00:27 PM EDT

The answer is NO. DB2/400 doesn't scope temp tables to sp's. -NT - (mmoffitt) - (1) - Dec. 21, 2004, 02:07:06 PM EST

Are they session/user scoped? -NT - (ChrisR) - Dec. 21, 2004, 02:09:19 PM EST

People don't pay that kind of money to walk around sober.
64 ms