DB2/400 or DB2/iSeries question.

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

Welcome to IWETHEY!

Post #168,445 by mmoffitt 8/10/04 11:51:44 AM Reply	DB2/400 or DB2/iSeries question. I know the "CREATE GLOBAL TEMPORARY TABLE" syntax, but suppose I want to create a temporary table in a stored procedure that lives only within that sp? What is the 400/iSeries syntax for doing so? TIA. bcnu, Mikem If you can read this, you are not the President.
Post #168,448 by deSitter 8/10/04 12:03:59 PM Reply	Re: DB2/400 or DB2/iSeries question. What is this, moral COBOL? IMAGINE WHIRLED PEAS. CREATE GLOBAL TEMPORARY TABLE. ... STOP. END. -drl
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

You've got a lot of repressed feelings, don't you?
81 ms