view based on global temporary table

baloo99 · #1 (**permalink**) 01-21-08, 05:42

Hi all,
i have next problem: i need make view based on declared global temporary table.
i can make procedure, open cursor, but i dont know how to return values using table function.
some ideas?
thanks.

version 8.2.3 LUW

ARWinner · #2 (**permalink**) 01-21-08, 08:14

You cannot directly define a view of a global temp tables. I do not think you can declare a global temp table in a UDF either.

Andy

jsharon1248 · #3 (**permalink**) 01-21-08, 09:21

Quote:

i need make view based on declared global temporary table

Why? Even if you could, I can't think of a reason that you'd want to.

Code:

The DECLARE GLOBAL TEMPORARY TABLE statement defines a 
temporary table for the current session. The declared temporary table 
description does not appear in the system catalog. It is not persistent and 
cannot be shared with other sessions. Each session that defines a declared 
global temporary table of the same name has its own unique description of 
the temporary table. When the session terminates, the rows of the table are 
deleted, and the description of the temporary table is dropped.

baloo99 · #4 (**permalink**) 02-25-08, 13:04

jsharon1248: i need obtain set of values from another system. all features, that you describe, makes from temporary table ideal candidate for restriction of result set. i have some existing application based on view. i cannot use temporary table with this view. in oracle this is possible.

ARWinner · #5 (**permalink**) 02-25-08, 13:16

Quote:

Originally Posted by baloo99

jsharon1248: i need obtain set of values from another system. all features, that you describe, makes from temporary table ideal candidate for restriction of result set. i have some existing application based on view. i cannot use temporary table with this view. in oracle this is possible.

I do not understand what you want to do. Can you elaborate further?

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech