Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85

    Unanswered: view based on global temporary table

    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
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Apr 2007
    Location
    Chicago
    Posts
    68
    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.

  4. #4
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    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.
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •