Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    India
    Posts
    6

    Question Unanswered: Declared and Created Temp Tables

    Hi,
    What is the difference between DECLAREd and CREATEd GLOBAL TEMPORARY TABLES? Also, how can I create temporary tables using CREATE statement (I am working on DB2v8.1/ Unix).
    Thanks,
    Shetty

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Shetty,
    FIrst, a Declared temporary table is only available as long as the session is active or the table is not dropped explicitly. There really is no such thing as a created temporary table, at least physically, in DB2. Any table that is Created will be available until it is dropped. Now, you can "create" a table to be used as a temporary table for whatever purpose you deem necessary, just remember that it is your responsibility to clean up after yourself.

    HTH

    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
  •