Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    39

    Unanswered: INDEXES on TEMPORARY TABLE ?

    DB2 V7 & V8 on UNIX (AIX, SunOS, Linux, ...) :

    I'm wondering if it is possible to create INDEX on DECLARED GLOBAL TEMPORARY TABLE and if it is a way to declare any indexes on a temporary table.

    Thanks in advance.
    geoffrey
    - Four J's Development Tools -

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    It is possible on V8 but not on V7

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2005
    Posts
    1
    How can we do it in V8?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    What do you mean ???



    Quote Originally Posted by gutta_99
    How can we do it in V8?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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